Hello, I have purchased your plugin because i saw the option that with user ID only users could edit their own data.
I thought it was possible to do something similar with google spreadsheets conected tables: filtering records by user id in the way users can see only their own data.
Thank you for the quick reply. I hace already seen that documentation (I believe I have read all the site documentation already). My question was not realated to editable tables from a template, I would like to do the same but with tables which are linked to an existing google spreedsheet for example, to be automatically uptaded when a change would be done in the google spreedsheet side.
As I understand you now, that spreadsheet will be displayed to all users and when some user enter data in that spreadsheet that data is updated to table but that same user when it is viewing/editing the table can see only their own data that is entered in the spreadsheet.
Yes thats what Ï meant! But to be a bit more specifically:
I will only be the one who will enter the data on the google spreedsheet from many different users and them, users will see only their own data from the common table :). Even ideally, user will not be able to edit anything anywhere!
I believe this is something common for other users :)
I think that it is possible to achieve that. Here is my suggestion: When creating the Google Spreadsheet data add one column that will be the user ID ( where you will manually add the user an ID). Then when creating table with our plugin choose third option ( attachment 1)
Check option for table to be editable. Then check the option User can see and edit their own data and pass that user ID column as "User ID column". (attachment 2)
If you want for your user just to see the data then you can hide the Edit New and Delete button with some CSS.
This I did already, but the problem is that with this option, the table is created with a google spreedsheet data but i loose the functionallity about auto update the data when I enter new data on the google spreedsheet. Thus, with this option, as far as i understood, i would need to create manually the tables again every time i update something in the google spreedsheets and this is exactly what i want to avoid / automatize, isn't it?
Unfortunately it is not possible to achieve something like that. Only workaround is to do what Bogdan have told you but then you'll have to add/update data manually from the plugin and not from the Google Spreadsheet.
Hello, I have purchased your plugin because i saw the option that with user ID only users could edit their own data.
I thought it was possible to do something similar with google spreadsheets conected tables: filtering records by user id in the way users can see only their own data.
Is it any way to do that?
Thank you!
Hi Alejandro,
Thank you for your purchase.
You can take a look at our documentation where you can find out how to achieve your request.
Best regards.
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
Hi Bogdan,
Thank you for the quick reply. I hace already seen that documentation (I believe I have read all the site documentation already). My question was not realated to editable tables from a template, I would like to do the same but with tables which are linked to an existing google spreedsheet for example, to be automatically uptaded when a change would be done in the google spreedsheet side.
Thank you again.
Alejandro.
Hi Alejandro,
Sorry for misunderstanding.
As I understand you now, that spreadsheet will be displayed to all users and when some user enter data in that spreadsheet that data is updated to table but that same user when it is viewing/editing the table can see only their own data that is entered in the spreadsheet.
Correct me if I am wrong.
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
Yes thats what Ï meant! But to be a bit more specifically:
I will only be the one who will enter the data on the google spreedsheet from many different users and them, users will see only their own data from the common table :). Even ideally, user will not be able to edit anything anywhere!
I believe this is something common for other users :)
Thank you Bogdan!
Hi Alejandro,
I think that it is possible to achieve that.
Here is my suggestion:
When creating the Google Spreadsheet data add one column that will be the user ID ( where you will manually add the user an ID).
Then when creating table with our plugin choose third option ( attachment 1)
Check option for table to be editable.
Then check the option User can see and edit their own data and pass that user ID column as "User ID column". (attachment 2)
If you want for your user just to see the data then you can hide the Edit New and Delete button with some CSS.
Let me know the result.
Best regards.
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
Hi again!
This I did already, but the problem is that with this option, the table is created with a google spreedsheet data but i loose the functionallity about auto update the data when I enter new data on the google spreedsheet. Thus, with this option, as far as i understood, i would need to create manually the tables again every time i update something in the google spreedsheets and this is exactly what i want to avoid / automatize, isn't it?
Thank you
Hi Alejandro,
Unfortunately it is not possible to achieve something like that. Only workaround is to do what Bogdan have told you but then you'll have to add/update data manually from the plugin and not from the Google Spreadsheet.