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

    Combining the submitted data from old form to a new one

    Asked by rrupert on December 17, 2015 at 04:24 PM

    I tried the apps for Combining Submissions and Importing Data. There is a limit of 60 fields on both of these apps. My form has close to 100 fields. They will not be useful unfortunately.

    Corrupted form (80 submissions) : https://form.jotform.com/53258278714968

    New form (currently at 27 submissions) : https://form.jotform.com/53425957926973

  • Profile Image

    Answered by Ben on December 17, 2015 at 04:34 PM

    I am sorry to hear that it would not work for you. Unfortunately these limits will not be increased.

    I do have one other idea that might work for you.

    If you set your new form to send the data to Google Spreadsheet, you could then combine the data there.

    How would it work:

    1. Set up Google Spreadsheet integration on your new form: How to Integrate Form with Google Spreadsheet

    2. Get the Excel file of all submissions on your original form: How to Export Form Data to Excel?

    3. Upload the Excel file to Google so that you get a new Google Sheet with the data from that Excel file.

    4. Use ImportRange() function of Google Spreadsheets to import the data from the new form into this new spreadsheet as it comes in.

    You can see more about this function on Google Help Article.

    Basically, in the first empty cell under the last row from the imported excel file, you add a code like this:

    =importrange("SpreadsheetCreatedByIntegrationKeyGoesHere", "A1:Z1000");

    If you have any questions in regards to this, please do let us know.