Hi! I have successfully created charts with data from google sheets... however, I only want each user to see their own data. Their userid (and email) are in the data sheet.
Put simply, how can I apply a filter so that the chart a user sees only contains their own data (ie the table is pre-filtered by "userid=" or "email=" prior to loading up the chart)
If you created the table by linking to the Google Spreadsheet, unfortunately that cannot be done.
Users see and edit only own data feature can only be applied to editable tables, so tables linked to an existing data source cannot work with this feature. What you can do is import the Google Spreadsheet, but in that case, any data changed or added in the source file will not be seen in the table, or vice-versa.
Hi! I have successfully created charts with data from google sheets... however, I only want each user to see their own data. Their userid (and email) are in the data sheet.
Put simply, how can I apply a filter so that the chart a user sees only contains their own data (ie the table is pre-filtered by "userid=" or "email=" prior to loading up the chart)
Thanks!
Hello Lee
Thank you for your purchase.
If you created the table by linking to the Google Spreadsheet, unfortunately that cannot be done.
Users see and edit only own data feature can only be applied to editable tables, so tables linked to an existing data source cannot work with this feature. What you can do is import the Google Spreadsheet, but in that case, any data changed or added in the source file will not be seen in the table, or vice-versa.
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