Google Sheet feeding multiple wpdatatables auto toggles “show/hide” columns ON

  • Resolved beansandcornbread

    (@beansandcornbread)


    5 years, 1 month ago

    Hi,
    So we use a Google spreadsheet (of businesses we serve) to feed a wpDataTable, and we have created individual pages (for each business) from this table. To do this we need to toggle the columns of the spreadsheet we want to show/hide for each page.
    When we change any info in the first column on the google spreadsheet (ie. business names), or add a new row for a new business, this change automatically toggles “show” for the new or changed column on all of our individual tables/pages.
    Is there anyway to prevent this?
    (It doesn’t show immediately, but if we make any change to an individual table or merely hit the “Apply” button on any individual table.)

    OR, is there a way to create a master table within wordpress that will auto-fill subsidiary tables the way we want? It appears that changes made within a “master” wpdatatable do not feed into its subsidiaries the way it does with Google spreadsheets…

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

  • [Update: beansandcornbread was an old profile for me. I have now re-registered and linked my profile to the website with which we are having the issue, https://www.focuscm.com — Thanks.]

    Plugin Author wpDataTables

    (@wpdatatables)

    Hi there.

    Sorry for the late response.

    If we understood you correctly, you have one Google Spreadsheet, which you want to use for several businesses?

    If this is true, all changes made in the Google Spreadsheet will be shown on all wpDataTables created from that sheet.

    Also, please note that you shouldn’t add new, delete, rename or rearrange existing columns in the original spreadsheet, or the tables created from it will break, and you will need to recreate them again.

    Please explain in a bit more detail if we failed to understand what the issue is.

    Kind regards.

    mikefocuscm

    (@mikefocuscm)

    Hi, good to hear from you.
    Yes, we are looking for a spreadsheet to which we CAN add new columns — since each column represents unique business info, and we frequently are adding new businesses we service. We also occasionally may wish to add an extra line item detail for all businesses.
    I hear you saying we cannot do this without going through and re-toggling the columns for each sub-table… That is too bad. Because what happens is not that we need to recreate them so much as the new columns simply get toggled on for each sub-table, and we have to go and turn them all off. It would seem to be solved for us if the default was to be toggled to “hide” instead of “show”…
    Thanks,
    Mike

    Plugin Author wpDataTables

    (@wpdatatables)

    Hello again.

    Well, here’s what you can also try:

    Have one master sheet in the Spreadsheet. That will be the sheet which contains all columns.

    Then, create a new sheet (within the same spreadsheet) for every business, and use !IMPORTRANGE function to define the range which needs to be imported from the master sheet into these new sheets.

    Every sheet has its own URL you can use to create wpDataTables from, so it may just work like that.

    Kind regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Google Sheet feeding multiple wpdatatables auto toggles “show/hide” columns ON’ is closed to new replies.