I would like to allow end users to view their own records, however, I need managers to be able to see and review all records in the table and edit as necessary.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Yes you can, but you have to make one more table. From first table where you turn on option User can see and edit own data you can use table name from option MySQL table name for editing which you can find on Editing tab in table settings.
Then make another table from MySQL query like this:
SELECT * FROM table_name_for_editing
Instead of table_name_for_editing you will use table name from option MySQL table name for editing. Tneh set option Editor roles to managers and like this will be shown all data from all users and only managers can configure it.
I would like to allow end users to view their own records, however, I need managers to be able to see and review all records in the table and edit as necessary.
Is it possible to accomplish this?
Hi jfullerton1,
Thank you for your purchase.
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Yes you can, but you have to make one more table. From first table where you turn on option User can see and edit own data you can use table name from option MySQL table name for editing which you can find on Editing tab in table settings.
Then make another table from MySQL query like this:
SELECT * FROM table_name_for_editing
Instead of table_name_for_editing you will use table name from option MySQL table name for editing. Tneh set option Editor roles to managers and like this will be shown all data from all users and only managers can configure it.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables