10,001 Limit on Google Spreadsheet Integration

  • matrixxpictures
    Asked on January 28, 2015 at 5:19 PM

    Is there any way to fix this. I integrated on of our forms and all data just stop at 10,001 on Google Spreadsheet.

     

    If I add more rows it still won't add data to those rows. So technically the integration doesn't move the remaining missing data.

    Jotform Thread 505541 Screenshot
  • jonathan
    Replied on January 28, 2015 at 6:36 PM

    Unfortunately, that is indeed the row/submission limits in the Google spreadsheet integration.

    Please understand that unlike a full scale database platform like MySQL or MSSQL, the spreadsheet will massively under perform bloated with a lot of data.

    Perhaps you can consider also an alternative,like exporting the submission data instead to databases. JotForm have database apps integration that will allow you to export the submission data.

    MySQL Export

    Oracle Export

    MongoDB Export

    OR

    perhaps you can also breakdown the submissions into multiple form and google spreadsheet.

    That is by distributing the Google spreadsheet data into multiple spreadsheets.. and just used a single step-over spreadsheet that wont get full to 10,000 because you will be removing and transferring the data to other spreadsheets.

    Hope this help. Inform us if you need further assistance.

    Thanks!