What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Spreadsheet Integration: randomly missing records.

    Asked by ProjectcodeX 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

    Page URL:
    https://www.jotform.com/submissions/70803061127951

  • Profile Image
    JotForm Support

    Answered by BDAVID 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

    Answered by ProjectcodeX 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
    JotForm Support

    Answered by BDAVID 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

    Answered by ProjectcodeX 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

    Answered by Sven 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

    Answered by ProjectcodeX 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
    JotForm Support

    Answered by BDAVID 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.