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.
Google Spreadsheet re-integration not fetching the last 5k submissionsAsked by linfoxt on December 03, 2015 at 02:27 AM
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
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.
Remember that there is a gap between submissions that have been fetched
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.
Check the image below, it clearly shows the gap
Thank you for the clarification. I have noted the gap in the report.