I run a supplemental education centre and have lots of google sheets. For example: class register, test results, course completion, etc. All sheets have a common column which is the students full name. Can your wpDataTables plugin allow me to display rows of data in each sheet based on the wordpress user's full name or login name? So, I want to give the user view-only access to all data in all sheets and display it on a page in wordpress. Is that possible, please? The wordpress user accounts are created based on a google sheet and zapier. That google sheet is used to populate all full name columns in all the other google sheets. And as more data is added to all the sheets, I'd like that to show as well.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You can create one wpDataTable from one Google Spreadsheet, and combining them is not possible.
The only way you could implement existing data would be to import all those Google Spreadsheets, which would create a manual table for every Spreadsheet. In that case, the two tables (wpDataTable and Google Spreadsheet) wouldn't be linked in any way, so changes made in Google Spreadsheet will not be seen in the table, or vice versa.
If you decide this would help, you would then be able to create a custom SQL query, possibly with JOIN functions, which would connect all these tables based on full name.
and thought that if you can display a row based on WP UserID, then may be if I link that ID to all the full names, I may be able to achieve what I need? So, yes as you said, import all my google sheets into wpData Tables (with a UserID column) and then use something like zapier to keep the sheets and new wpDataTables SQL tables synchronized?
I run a supplemental education centre and have lots of google sheets. For example: class register, test results, course completion, etc. All sheets have a common column which is the students full name. Can your wpDataTables plugin allow me to display rows of data in each sheet based on the wordpress user's full name or login name? So, I want to give the user view-only access to all data in all sheets and display it on a page in wordpress. Is that possible, please? The wordpress user accounts are created based on a google sheet and zapier. That google sheet is used to populate all full name columns in all the other google sheets. And as more data is added to all the sheets, I'd like that to show as well.
Hello Mushfiqur Rahman
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You can create one wpDataTable from one Google Spreadsheet, and combining them is not possible.
The only way you could implement existing data would be to import all those Google Spreadsheets, which would create a manual table for every Spreadsheet. In that case, the two tables (wpDataTable and Google Spreadsheet) wouldn't be linked in any way, so changes made in Google Spreadsheet will not be seen in the table, or vice versa.
If you decide this would help, you would then be able to create a custom SQL query, possibly with JOIN functions, which would connect all these tables based on full name.
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
I watched this wpDataTables video:
and thought that if you can display a row based on WP UserID, then may be if I link that ID to all the full names, I may be able to achieve what I need? So, yes as you said, import all my google sheets into wpData Tables (with a UserID column) and then use something like zapier to keep the sheets and new wpDataTables SQL tables synchronized?Hello Mushfiqur.
That is a good idea, but unfortunately we don't have integration with Zapier yet.
Even if we did, I don't know if you'd be able to create an editable relation between wpDataTable and Google Spreadsheets.
At the moment, it's not possible with the built in features, and any custom work doesn't fall under included support of the plugin.
Sorry for the inconvenience.
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