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.
When Google Sheets and JotForm are integrated for multiple forms, it integrates all submissions into one Google Sheet instead of multiple ones.Asked by LCaraccilo on July 15, 2015 at 12:36 PM
When Google Sheets and JotForm are integrated for multiple forms, it integrates all submissions into one Google Sheet instead of multiple ones. When Google Sheets and JotForm are integrated, I need it to create multiple sheets and have the submissions to be collected under the appropriate sheet.
When you integrate Google Spreadsheet to your Form, it will create only one spreadsheet. Currently, when you remove and reintegrate, it creates a new spreadsheet per instance, the old spreadsheet will remain in your Google Drive but it will no longer be connected to your form.
It is a one way integration where the Form transfers the data to the newly created spreadsheet, you cannot pass data from Spreadsheet to the Form, you also cannot connect your own spreadsheet to the form.
Please check our guide here: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet.
Note: Every time that remove and re-integrate Google Spreadsheet, it automatically loads all the submissions in the newly created spreadsheet.
If you want to compile multiple Forms with their Google Spreadsheets to one main Sheet (a master sheet), you can use the ImportRange function for that.
I hope that helps.
Is there another tool I could use to do what I am looking for it to do? Please help! Thanks!
Sorry but I don't think there's any feature that would fit your requirement. The only option I could think of that would be automated is to create your own webhook script, this requires advanced php knowledge though. http://www.jotform.com/help/245-Creating-your-first-Webhook-with-JotForm
Other than that, you may consider PDF format instead. When you integrate to Google Drive, submissions data will be sent into PDF format.