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 re-integration not fetching the last 5k submissions

    Asked by linfoxt on December 03, 2015 at 02:27 AM

    Hi Guys,

    I have a form that has almost 80k submissions, this form receives an average of 300 submissions / day, so this number will grow and grow.

    I've re created the integration due a problem with the integration, but I 1594 submissions starting with submission from 2014 and then suddenly it jumped to 2015. Please could you check? I really need this working as I generate daily reports based on this.

    I don't know the reason, but the integration with the Google Spreadsheet has been lost yesterday, I know that is not simple to create 80k spreadsheet; however, as I've been told on this topic, the Google Spreadsheet will limit to 5k submissions to avoid issues.

    Form ID = 42227401036947

    google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Welvin on December 03, 2015 at 05:33 AM

    The way how I understand it is that the new google spreadsheet integration is only fetching the last 2400+ submissions instead of the 5000 submissions as mentioned by our developer in the original thread.  The 2400+ is the number based on your spreadsheet.

    I have forwarded this thread to our developers and if there are updates, you should know it through this thread. 

    Thanks

  • Profile Image

    Answered by linfoxt on December 03, 2015 at 01:11 PM

    Remember that there is a gap between submissions that have been fetched

  • Profile Image
    JotForm Support

    Answered by Charlie on December 03, 2015 at 01:26 PM

    To clarify, what you meant by a gap, is that there are submissions that weren't fetched in between? For example, it jumped to another submission to start on the spreadsheet and skipped the others, is that correct?

    I see my colleague has already forwarded this to our developers.

  • Profile Image

    Answered by linfoxt on December 03, 2015 at 01:32 PM

    Yes,

    Check the image below, it clearly shows the gap

  • Profile Image
    JotForm Support

    Answered by Welvin on December 03, 2015 at 01:44 PM

    Thank you for the clarification. I have noted the gap in the report.