Google Spreadsheet: Not Always Updating

  • PUREInsurance
    Asked on January 29, 2018 at 9:33 AM

    So far, our integrated Google Spreadsheet has been working well, but now we find random registrants that are not syncing and appearing in the Google Spreadsheet. Can someone please help us understand why and how to fix?

    Page URL: https://form.jotform.com/PUREInsurance/plf2018
  • aubreybourke
    Replied on January 29, 2018 at 12:04 PM

    I tried pushing the missing submissions through to your spreadsheet. But it dint work.

    So I will have to escalate this issue to Level 2 support.

    They will examine the problem and post a response on this thread when they are ready.

  • PUREInsurance
    Replied on January 29, 2018 at 1:36 PM

    Thank you! Yes, please keep me posted!

  • Denis VP of Engineering, Enterprise
    Replied on January 30, 2018 at 9:09 AM

    Hello,

    Sorry for the trouble, I've checked our logs and it seems you have removed your Submission-ID column which breaks the integration. We know most of our users do not want to see random numbers but it's necessary for integration to work. We recommend our users to hide the columns that they do not want to see.

     1517321001Screen Shot 2018 01 29 at 2 Screenshot 10

    In your case, the only solution is removing integration of your form and integrate with Google Spreadsheets again. We apologize for the inconveniences caused. 


    If you need any further assistance please feel free to contact us anytime.


    Regards.