We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

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.