We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
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