Hey there, Awesome Customers!
Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.
During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.
We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.
Thanks a bunch for your understanding and support!
Catch you on the flip side!
Warm regards,
TMS
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