We are looking at installing this WpDataTables for one of our clients on their site and had a question about the functionality. We see that the plugin allows front-end editing and has an option for allowing people to only see and edit their own information. Is there a setting to allow users to see all the data, but only update their own? We will be using this as a contact database and need users to be able to see all the data but only edit data pertaining to themselves.
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
This feature can only show and allow editing of own entries. You can, however, create an SQL query-based table from this table, which would be used to show all entries, without editing possibility.
For example, if the table with "Users see and edit only their own data" is a manual table, you can go to the Editing tab above the table, and copy the "MySQL table name for editing". Then create a new SQL query-based table with:
SELECT * FROM wp_wpdatatable_12
If we assume the manual table's "MySQL table name for editing" is "wp_wpdatatable_12" it will create a new, non-editable table and you can add it below the manual table on the same page.
We are looking at installing this WpDataTables for one of our clients on their site and had a question about the functionality. We see that the plugin allows front-end editing and has an option for allowing people to only see and edit their own information. Is there a setting to allow users to see all the data, but only update their own? We will be using this as a contact database and need users to be able to see all the data but only edit data pertaining to themselves.
Is this a possibility with this plugin?
Hello Chuck.
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
This feature can only show and allow editing of own entries. You can, however, create an SQL query-based table from this table, which would be used to show all entries, without editing possibility.
For example, if the table with "Users see and edit only their own data" is a manual table, you can go to the Editing tab above the table, and copy the "MySQL table name for editing". Then create a new SQL query-based table with:
SELECT * FROM wp_wpdatatable_12
If we assume the manual table's "MySQL table name for editing" is "wp_wpdatatable_12" it will create a new, non-editable table and you can add it below the manual table on the same page.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables