I've succeeded generating a table by linking my wpdatatable to a mysql table that has a csv file imported.
I'd like to be able to import a google spreadsheet now into a mysql table so I can now use that mysql table for my wpdatatable. Is this something possible? I'd like this because google sheets contains real-time data.
The reason I prefer mysql is it's fast. I am currently using a wpdatatable that gets its data from a google sheet. but it's quite slow and creates problems because I only share the google spreadsheet with myself via API.
Unfortunately, this is not something that could be done with wpDataTables.
You would need to find a way to link the Google Spreadsheet with your database table, and then you would simply create an SQL query-based table in wpDataTables. How you will establish that connection, though is not something that can be achieved with our plugin, and it's not something I can help you with.
hi,
I've succeeded generating a table by linking my wpdatatable to a mysql table that has a csv file imported.
I'd like to be able to import a google spreadsheet now into a mysql table so I can now use that mysql table for my wpdatatable. Is this something possible? I'd like this because google sheets contains real-time data.
The reason I prefer mysql is it's fast. I am currently using a wpdatatable that gets its data from a google sheet. but it's quite slow and creates problems because I only share the google spreadsheet with myself via API.
Thanks for any tips!
Hello IW
Unfortunately, this is not something that could be done with wpDataTables.
You would need to find a way to link the Google Spreadsheet with your database table, and then you would simply create an SQL query-based table in wpDataTables. How you will establish that connection, though is not something that can be achieved with our plugin, and it's not something I can help you with.
Please take a look at this page, I hope it helps.
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