"Administrator view" (#1641540) / TMS-Plugins

jfullerton1 started the conversation
July 13, 2018 at 11:30pm
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?
472
Isidora replied
July 16, 2018 at 8:03am
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