JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How to combine submissions in one Google Spreadsheet file?Asked by lisascy on March 14, 2016 at 02:54 AMI am trying to use your option 2, i.e using Google Spreadsheet but I have noticed that every time I do an integration from another form, it creates a new spreadsheet with the same name and not just collect the submissions into just 1 file. Is there a way around this as that won't combine the submissions.
Unfortunately, the spreadsheet will not collect the submissions from 2 forms into one file, even if the name is the same. Every time you integrate a from with google spreadsheet, a new spreadsheet will be created. For more information on the integration, you can check out this guide: How to Integrate Form with Google Spreadsheet
You can try using this add-on to merge the two sheets together: Merge Sheets Add-on. However, do note that doing this might cause issues with the integration of google spreadsheet with the form. The next submissions may not be received in the spreadsheet correctly.
A possible alternative would be to use the Combine Submissions App to combine the submissions: http://apps.jotform.com/app/combine_submissions
If you need further assistance, do let us know.