Something like this is not possible since users can't select columns or rows in the table; also, even if this was possible, they are not able to create new tables from the front-end based on that selection. New tables can only be created by admins in the back-end.
You can, however, have one master table, where you would include a "User ID" column, where the WordPress User IDs of your users would be stored. If this is a server-side table (manual table, for example), you can create a new MySQL query-based table from that table that would use the "Users see and edit only own data" feature.
So, you would go to the Editing tab of the master table, enable editing to copy the MySQL Table Name value. It's saved as wp_wpdatatable_# by default (where wp_ is the database prefix, so it could be something else on your end, and # is the ID of the table).
A new table for your users would be generated with a simple query:
SELECT * FROM wp_wpdatatable_12
You'd change the ID of the table in your query.
That new table could be displayed on another page in the front-end, and you'd select the User ID column as the User ID column in the Editing tab above the table when you enable the "Users see and edit only own data" feature. You could disable all editing buttons on the front-end using the CSS mentioned on this page.
Please let us know if you have any further questions.
Hi,
I have a large table that will be available for users to view filter etc.
i would like the users to be able to select some rows based on a column like “Name” and create their own table that they can view on their page.
So whenever the original table (large dataset) is updated, the user sees their own selection updated from the original table.
How is this possible?
thanks!!
Hey Syed
Sorry for the late response.
Something like this is not possible since users can't select columns or rows in the table; also, even if this was possible, they are not able to create new tables from the front-end based on that selection. New tables can only be created by admins in the back-end.
You can, however, have one master table, where you would include a "User ID" column, where the WordPress User IDs of your users would be stored. If this is a server-side table (manual table, for example), you can create a new MySQL query-based table from that table that would use the "Users see and edit only own data" feature.
So, you would go to the Editing tab of the master table, enable editing to copy the MySQL Table Name value. It's saved as wp_wpdatatable_# by default (where wp_ is the database prefix, so it could be something else on your end, and # is the ID of the table).
A new table for your users would be generated with a simple query:
SELECT * FROM wp_wpdatatable_12
You'd change the ID of the table in your query.
That new table could be displayed on another page in the front-end, and you'd select the User ID column as the User ID column in the Editing tab above the table when you enable the "Users see and edit only own data" feature. You could disable all editing buttons on the front-end using the CSS mentioned on this page.
Please let us know if you have any further questions.
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