I have successfully synced and published tables via Google Sheets and when I change values in Google Sheets the changes are reflected (after a few minutes) on my website.
However when I add a new column in Google Sheets the changes are not synced. I have to manually press Apply in the Data Source on each of the tables in wpDataTables plugin.
Note - I'm not changing anything in the Data Source just clicking Apply - for changes to load. After that everything works as normal.
Is this a known limitation of the sync with Google Sheets?
I have successfully synced and published tables via Google Sheets and when I change values in Google Sheets the changes are reflected (after a few minutes) on my website.
However when I add a new column in Google Sheets the changes are not synced. I have to manually press Apply in the Data Source on each of the tables in wpDataTables plugin.
Note - I'm not changing anything in the Data Source just clicking Apply - for changes to load. After that everything works as normal.
Is this a known limitation of the sync with Google Sheets?
Hello Pontus.
Thank you for your purchase.
Yes, adding new columns in the source file may even result in the table breaking.
Please note: Once you create a table from a Google Spreadsheet, changes in the core file from which a table is created, like:
are highly not recommended, because the old table may not work. If you make any of these changes, you may need to recreate the table again.
This goes for Excel and CSV based tables too.
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