Comments 1Clem started the conversationJuly 12, 2022 at 11:35pmHi TMS team,I added some tables to a page for my client to be able to edit some dataI would like them to be only able to edit data included in a few columns, not all columns. Do you think there is a way to do this?Thank you!Clement 1,851Miloš repliedJuly 14, 2022 at 3:59pmHi, ClementSorry for the delayYes. The easiest way to achieve this is, you can create one "main table" for Administrators to edit,and you can make an SQL Query from this table, to present this one for front-end clients.For example, main Manual table;And then find what is the SQL name of the table on the Editing tab, like this :Make a new SQL Query based table, like this :SELECT * FROM wp_wpdatatable_4 ( In your case it can be different table number):And you will have another table, that you can place on the page for clients;This table will pull data from the main table, and you can set only certain columns - to be edited;for columns you don't wish to allow them to edit, just set Editor Type as NONE :Let me know how this sounds? Thank youKind Regards, Miloš Jovanović[email protected] Rate my supportTry our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/ 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 Sign in to reply ...
Hi TMS team,
I added some tables to a page for my client to be able to edit some data
I would like them to be only able to edit data included in a few columns, not all columns. Do you think there is a way to do this?
Thank you!
Clement
Hi, Clement
Sorry for the delay
Yes. The easiest way to achieve this is, you can create one "main table" for Administrators to edit,
and you can make an SQL Query from this table, to present this one for front-end clients.
For example, main Manual table;
And then find what is the SQL name of the table on the Editing tab, like this :
Make a new SQL Query based table, like this :
SELECT * FROM wp_wpdatatable_4
( In your case it can be different table number):
And you will have another table, that you can place on the page for clients;
This table will pull data from the main table, and you can set only certain columns - to be edited;
for columns you don't wish to allow them to edit, just set Editor Type as NONE :
Let me know how this sounds? Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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