As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2825508
Google Sheets
Closed

Comments

  •  1
    Manuel Ayuso started the conversation
    July 14, 2021 at 8:51am

    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!

  • [deleted] replied
    July 14, 2021 at 12:18pm

    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:

    • Changing the column’s name,
    • Changing the column’s order,
    • Deleting the column, and
    • Adding a new column.

    are highly not recommended, because the old table could break. If you make any of these changes, please recreate the table again.

  •  1
    Manuel Ayuso replied
    July 14, 2021 at 12:36pm

    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


  • [deleted] replied
    July 14, 2021 at 1:42pm

    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.

  •  1
    Manuel Ayuso replied
    July 14, 2021 at 3:22pm

    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

  • [deleted] replied
    July 15, 2021 at 7:28am

    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.