Okay
  Public Ticket #1848476
table not updating when google sheets is updated...2 hrs later
Open

Comments

  •   johnhatheway started the conversation
  •  32
    Aleksandar replied

    Hello johnhatheway.

    Thank You for Your purchase.

    I've created a table from the URL, and it shows the data correctly. From what I understand, it doesn't update the data when You change it in Google Spreadsheets, correct?

    Please note that when You create a table from Google spreadsheet, You cannot add or delete columns, because there is a possibility the table will stop working.

    Other than that, we haven't had any issues with table updating from Google Spreadsheets. I noticed You have 4 sheets in that document, so I have to ask - are You using 4 different URLs for 4 different wpDataTables tables?

    If You'd like, You can provide me with a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. Also, if You can enable us to edit the Google Spreadsheet, so that we can add or delete TEST rows to try and replicate the issue on our end. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com

  •   johnhatheway replied privately
  •  32
    Aleksandar replied

    Hello again John.

    I logged in for a bit, but I didn't want to change much. I saw You were logged in the google spreadsheet in the same time, so I didn't want us to cancel each other out.

    Anyway, I changed the lift capacity for Tube Park from 1 to 2, just for testing purposes, and after about 5 minutes it reflected in the [WPDATATABLE ID=1] (see attachments). I changed it back to 1, don't worry.

    Now, my guess is that it's not updating when You add a new ●, correct?

    If that's true, it may be because of the formatting, as it is said in our documentation:

    • Also, don’t apply any formatting in this new sheet. You can make whatever adjustment you may need in WpDataTables.

    So, if this is the case, my advice would be to add copies of the existing sheets in the same document. You have "Lifts", "Easiest", "More Difficult", "Most Difficult" and "Experts Only"; so add 5 more sheets and name them like "Copy of Lifts", "Copy of Easiest", etc.

    After You do, You can add any formatting You like, formulas and so on, but the only data You'd be entering in these new sheets would be a =IMPORTRANGE function in cell A1.

    So, for instance, in a new sheet "Copy of Lifts", You'd need to enter the following in cell A1:

    =IMPORTRANGE("https://docs.google.com/spreadsheets/d/17zJaTj9H2qVNsVi5pcUL6oAgzv-b8C0-6sZYyOgVkuI/edit#gid=0","Lifts!A1:C7")

    You'll probably need to add a permission for this (it'll be a popup in the A1 cell) and after a couple of minutes, it'll copy the data from the given range (A1:C7). Now, if You plan to extend the number of rows, You can modify the range to be (for example) A1:C27, so that the data that's been added would be copied without modifying the formula.

    After that, You'd copy the URL from the new "Copy of Lifts" sheet and paste it in the table's URL link, and that's it. After that, the ● should be applied after a few minutes.

    Please let me know if this helps.

    Best regards.

    Attached files:  Selection_081.png
      Selection_080.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com