Google Spreadsheet re-integration not fetching the last 5k submissions

  • Profile Image
    linfoxt
    Asked 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

  • Profile Image
    Welvin
    Answered 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
    linfoxt
    Answered on December 03, 2015 at 01:11 PM

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

  • Profile Image
    Charlie
    Answered 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
    linfoxt
    Answered on December 03, 2015 at 01:32 PM

    Yes,

    Check the image below, it clearly shows the gap

  • Profile Image
    Welvin
    Answered on December 03, 2015 at 01:44 PM

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