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

    10,001 Limit on Google Spreadsheet Integration

    Asked by matrixxpictures on January 28, 2015 at 05: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.

    Screenshot
    integrated move rows spreadsheet limit row limit
  • Profile Image
    JotForm Support

    Answered by jonathan on January 28, 2015 at 06: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!