For my use case, I want to allow users to edit only their own data, but I want to be able to select a moderator for a data set. Someone who is not admin who can edit another users data from the front-end.
Preferably this could also include limiting moderators to particular columns only, for example to mark entries as 'open/closed' or mark as 'resolved'.
Another feature would be front-end form building, and front-end data building (basically putting backend/administrative tools into front-end). Possibly integrating with buddypress profiles.
Do you think any of this functionality is possible?
We do not have option to assign moderator to the table where "Users see and edit only own data" option is turned on, but you can create one more table (MySQL) and in that table show all the data from the first one. You will then need to find a way to show this table only to the moderators in the front end and on of the ways would be to create custom template for that page and on that page to write a logic which will check if the user has appropriate role and show them first or the second table accordingly. To restrict moderators to edit only particular column/s you need to add editor input type only for that column and set it to "None" for all others. We do have option to allow users to add or edit data from the frontend and also integration with popular form builders through addons.
You can see and test all of this features in our sandbox website: sandbox.wpdatatables.com username: demo password: demo
Hey!
Awesome looking plugin, congratulations!
For my use case, I want to allow users to edit only their own data, but I want to be able to select a moderator for a data set. Someone who is not admin who can edit another users data from the front-end.
Preferably this could also include limiting moderators to particular columns only, for example to mark entries as 'open/closed' or mark as 'resolved'.
Another feature would be front-end form building, and front-end data building (basically putting backend/administrative tools into front-end). Possibly integrating with buddypress profiles.
Do you think any of this functionality is possible?
Best wishes, S.
Hi Shane,
We do not have option to assign moderator to the table where "Users see and edit only own data" option is turned on, but you can create one more table (MySQL) and in that table show all the data from the first one.
You will then need to find a way to show this table only to the moderators in the front end and on of the ways would be to create custom template for that page and on that page to write a logic which will check if the user has appropriate role and show them first or the second table accordingly.
To restrict moderators to edit only particular column/s you need to add editor input type only for that column and set it to "None" for all others.
We do have option to allow users to add or edit data from the frontend and also integration with popular form builders through addons.
You can see and test all of this features in our sandbox website:
sandbox.wpdatatables.com
username: demo
password: demo