Google Spreadsheet Integration: randomly missing records.

  • Profile Image
    ProjectcodeX
    Asked on July 14, 2017 at 07:48 AM

    Hi 

    We noticed that some of our submissions are missing from the Google Spreadsheet integration.

    We've just run a comparison of the submissions downloaded in excel format from the Jotform site, and the submissions in the Google Spreadsheet, and 12 were missing in Google.

    I can't see any strange data in the fields.

    Please can you help us resolve this, as we have missed records since May!

     

    Kind regards,
    Cara

  • Profile Image
    BDAVID
    Answered on July 14, 2017 at 11:35 AM

    We have pushed the missing submissions to your integrated spreadsheet, please check again, and let us know if you need more help.

  • Profile Image
    ProjectcodeX
    Answered on July 14, 2017 at 12:20 PM

    Hi

    Thank you for your response. Please could you let us know what caused the issue?

    The concern we have is not so much the past records (we have found them), but that we may miss future records. We don't want to be doing weekly comparisons for missing data...

    (and it was 1 and 2 records, from different forms - not 12 records missing - apologies for the confusion. The other form is https://www.jotform.com/submissions/63182631845963 and this one contained the one missing from May).

    Kind regards,

    Cara

  • Profile Image
    BDAVID
    Answered on July 14, 2017 at 01:09 PM

    The integration can break if you make edits on your spreadsheet. If the problem continues, we would recommend you to remove the integration, and then make a new integration. All the data will be properly update in the new spreadsheet.

  • Profile Image
    ProjectcodeX
    Answered on July 17, 2017 at 03:53 AM

    Thanks for the reply.

    We know about the integration breaking if we make changes, so we avoid making changes. The thing that is different is that the integration itself did not break - we still received records between and after the missing records, whereas when the integration breaks all records stop coming through.

    The concern we have, as above, is missing more records without knowing it.

    Please keep us informed about any progress on this issue.

    Kind regards,
    Cara

  • Profile Image
    Sven
    Answered on July 17, 2017 at 05:33 AM

    It could have been a temporary issue with the integration, as it may sometime break. As my colleague mentioned, I would recommend removing the integration and adding it again, and if the issue still persists, please let us know so we can look into it further. 

  • Profile Image
    ProjectcodeX
    Answered on August 10, 2017 at 10:26 AM

    Hi Jotform

    This issue has come up again for this form: https://www.jotform.com/submissions/70803061127951

    We removed and re-added the integration on 25 July. One of the submissions from 3 Aug was missing from the integrated Google Sheet, but we received items after that.

    Please can you investigate further - it really is worrying that we randomly miss records.

    Kind regards,
    Cara

     

  • Profile Image
    BDAVID
    Answered on August 10, 2017 at 11:38 AM

    We have synced the missing entry to your spreadsheet. I have also reported this to our back-end team to further investigate. You will be notified via this thread if there is any update.