I have linked my site (working on a local site now) with the Google Sheets API, and it is working fine. I can see the updates immediately. However, if I add a new column in google sheet, I can't see it immediately. I have to go to the Wordpress admin and resave the table to get the new column added to the tables.
Is there any way to fix this? Hope there is :-) Otherwise, is there any way to update (re save) all the tables at the same time? I will need to have a lot of tables on my site and it will be very tedious to save one at a time.
Unfortunately this is not possible, but I'll kindly ask you to leave your suggestion following this link and our developers will consider developing such a feature for one of our future updates.
Hi,
I have linked my site (working on a local site now) with the Google Sheets API, and it is working fine. I can see the updates immediately. However, if I add a new column in google sheet, I can't see it immediately. I have to go to the Wordpress admin and resave the table to get the new column added to the tables.
Is there any way to fix this? Hope there is :-) Otherwise, is there any way to update (re save) all the tables at the same time? I will need to have a lot of tables on my site and it will be very tedious to save one at a time.
Thanks!
Hi Manuel
Thank you for reaching out to us.
As stated in our documentation 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 could break. If you make any of these changes, please recreate the table again.
Hi Blaženka,
Oh I see. Bummer. So in that case is there any way to recreate several tables at the same time?
It would be really really helpfull.
Thanks again
Unfortunately this is not possible, but I'll kindly ask you to leave your suggestion following this link and our developers will consider developing such a feature for one of our future updates.
Hello Blaženka,
Ah, I see. What a pity :-(
Is there any way to achieve what I need, can it be using XML, JSON, EXCEL ?
I need to be able to add columns and reflect that in the frontend without resaving the tables in the wordpress backend.
Thanks
You cannot add new columns in a table linked to an existing data source. The only table type where you can add new columns is a manual table.
All other table types pull the data from a data source, so they don't have the possibility to add new columns.