Here's the ideal situation. I create an initial table with wpdatatables with Google sheet. Then, I can continue to edit the spreadsheet and it automatically updates to the table, or I can edit or add data directly in wpdt, or upload an additional spreadsheet to the existing table.
Problem with Google Sheets: Why does this have to be published to the web in order to work? I don't want my entire dataset available to search engines and accessible by everyone.
I don't see a way to add another spreadsheet upload to an existing database. I would rather not create multiple databases/tables when everything should be in the same database.
I wasn't able to find an answer in the documentation. What am I missing? Thanks.
The Spreadsheet needs to be published to the web because that is the only way wpDataTables can see it. If the document isn't published, wpDataTables can't connect to it, and fetch the data from it.
There's cache on Google's side, so when you update the table it might take up to 5-15 minutes to be reflected in the wpDataTable.
These tables are not editable from within the plugin, so if you need to edit the table, you will need to import the Google Spreadsheet, but in that case, the table will not be linked to the spreadsheet anymore. Meaning changes made in the sheet will not be seen in the table, and vice-versa.
If you wish to create a new table from another Sheet in the Spreadsheet, you will need to copy its URL, and there's no way you can include multiple sheets in one table.
Here's the ideal situation. I create an initial table with wpdatatables with Google sheet. Then, I can continue to edit the spreadsheet and it automatically updates to the table, or I can edit or add data directly in wpdt, or upload an additional spreadsheet to the existing table.
Problem with Google Sheets: Why does this have to be published to the web in order to work? I don't want my entire dataset available to search engines and accessible by everyone.
I don't see a way to add another spreadsheet upload to an existing database. I would rather not create multiple databases/tables when everything should be in the same database.
I wasn't able to find an answer in the documentation. What am I missing?
Thanks.
Hello Eufemia
The Spreadsheet needs to be published to the web because that is the only way wpDataTables can see it. If the document isn't published, wpDataTables can't connect to it, and fetch the data from it.
You can edit the Google Spreadsheet, and have the data updated in the table as well, if you create a table linked to the Google spreadsheet.
There's cache on Google's side, so when you update the table it might take up to 5-15 minutes to be reflected in the wpDataTable.
These tables are not editable from within the plugin, so if you need to edit the table, you will need to import the Google Spreadsheet, but in that case, the table will not be linked to the spreadsheet anymore. Meaning changes made in the sheet will not be seen in the table, and vice-versa.
If you wish to create a new table from another Sheet in the Spreadsheet, you will need to copy its URL, and there's no way you can include multiple sheets in one table.
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