We have several tables and it has to be updated at least once a month and it is a Google Spreadsheet.
Our issue:
When I rename a simple data in a header of a table in Google Spreadsheet tab (example: rename a name of a actual month) it doesn't show the right data, I have to open the specific table in wpdatatable and save it, otherwise it doesn't show at all. There's no cache on, no cache plugin, no cache on wpdatatable...
Is there any way to load the right data without I have to open in wpdatatable and save it to show the right data?
As I said I have several tables (more than 200) to update every month.
If you make any of the above changes, the wpDataTable will break. If you make any of these changes, you will need to recreate the table again.
-----
However soon as I save it on wpdatatable the right data is displayed, if so you give us a button "UPDATE selected tables" or "UPDATE ALL"? It will update in a bunch and will save loads of time. Let me know if there's an solution to it.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
You are correct, i can see that you found what is the issue through our Documentation.
That is a limitation we have with our Tables connected with source Google Sheet.
If you change a Header name/ or do any of these other changes to table structure on the Sheet,
unfortunately the table will become "messed up" in some way.
In some situations, it does not break but it lets you hit "Save Changes", such as in your case,
but in some cases it completely breaks the table and we have to make a new one,
that is why we don't recommend doing those steps.
-
2. I can see what you mean, but very sorry to disappoint you,
at the moment we do not have any kind of automated way or a button that might do "Save Changes to multiple tables" , so to speak.
For each table that you change the source data structure, you would have to go in each of them and hit "Save Changes" for the table to refresh and pick up the updated data source.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Hi,
We have several tables and it has to be updated at least once a month and it is a Google Spreadsheet.
Our issue:
When I rename a simple data in a header of a table in Google Spreadsheet tab (example: rename a name of a actual month) it doesn't show the right data, I have to open the specific table in wpdatatable and save it, otherwise it doesn't show at all. There's no cache on, no cache plugin, no cache on wpdatatable...
Is there any way to load the right data without I have to open in wpdatatable and save it to show the right data?
As I said I have several tables (more than 200) to update every month.
Thanks in advance!
Fabricio
Attached files: wpdatatable_error.jpg
I have read on documentation:
If you make any of the above changes, the wpDataTable will break. If you make any of these changes, you will need to recreate the table again.
-----
However soon as I save it on wpdatatable the right data is displayed, if so you give us a button "UPDATE selected tables" or "UPDATE ALL"? It will update in a bunch and will save loads of time.
Let me know if there's an solution to it.
Thanks again.
Hi, Fabricio.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
You are correct, i can see that you found what is the issue through our Documentation.
That is a limitation we have with our Tables connected with source Google Sheet.
If you change a Header name/ or do any of these other changes to table structure on the Sheet,
unfortunately the table will become "messed up" in some way.
In some situations, it does not break but it lets you hit "Save Changes", such as in your case,
but in some cases it completely breaks the table and we have to make a new one,
that is why we don't recommend doing those steps.
-
2. I can see what you mean, but very sorry to disappoint you,
at the moment we do not have any kind of automated way or a button that might do "Save Changes to multiple tables" , so to speak.
For each table that you change the source data structure, you would have to go in each of them and hit "Save Changes" for the table to refresh and pick up the updated data source.
But this is a good idea for a future option.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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