The data from Google Spreadsheets are not pulled in, in real time. There's cache on Google's side, and it takes 10 - 15 minutes for the data to be displayed in the wpDataTable created from a Google Spreadsheet.
Also, if you're creating tables linked to an existing sheet, you would not be able to display data only to the users who edited the Spreadsheet, as wpDataTables wouldn't know who that user is, as it's only pulling existing data from the Spreadsheet.
For Users to be able to see and edit only own data, the table would have to be editable (Manual, imported, or SQL query based), and in that case, the users will have to be logged into WordPress, and their User ID stored in the table the chart is created from.
Can I have a page that will show the specific charts from a survey based only on a user id?
our clients will be filling a survey and their results will create several charts and I’d like to to be able to see only their results.
Is this possible?
The data will be coming from a google sheets document.
Will their result be available in real time?
Will the client have to login somehow to see their results?
Please let me know If this is possible and I’ll make a purchase if so.
Hello Dustin
Thank you for your interest in our plugin.
The data from Google Spreadsheets are not pulled in, in real time. There's cache on Google's side, and it takes 10 - 15 minutes for the data to be displayed in the wpDataTable created from a Google Spreadsheet.
Also, if you're creating tables linked to an existing sheet, you would not be able to display data only to the users who edited the Spreadsheet, as wpDataTables wouldn't know who that user is, as it's only pulling existing data from the Spreadsheet.
For Users to be able to see and edit only own data, the table would have to be editable (Manual, imported, or SQL query based), and in that case, the users will have to be logged into WordPress, and their User ID stored in the table the chart is created from.
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