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 #3369267
Column Header update only after saving
Closed

Comments

  • Fabricio Piloto started the conversation

    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

  • Fabricio Piloto replied

    I have read on documentation:

    • Renaming columns,
    • Reordering columns,
    • Deleting existing columns,
    • Adding new columns.

    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.

  •  1,894
    Miloš replied


    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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