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.
How to connect one form to multiple Google sheetsAsked by dpuntier on December 24, 2015 at 11:54 AM
I have a form that is connected to a google sheet. However, I would like to use the same form to connect to about 4 different sheets. For example, in my jotform, a person would input a clients information and this information is transfer to my google sheet. I would like an option where the person filing out the form can have the option to pick from 4 different choices. I attached a screenshot as an example. Thank you.
Unfortunately, I believe this is not possible. The Google Spreadsheet integration creates a new spreadsheet giving a one way integration between JotForm and the generated spreadsheet.
This means you cannot create an integration in 1 form on 4 different spreadsheet, or 4 sheets on one spreadsheet.
What might be possible is this approach:
1. Create 5 Forms.
Form 1 - first form where a field will be used to identify to what spreadsheet we want to transfer the data. The form is submitted in Form 1 BUT we will redirect the user on a specific form based from their answer on the drop down list. I have also changed the text on the submit button to "Next", giving it a continuation effect.
Form 2, Form 3, Form 4 and Form 5 will have their own Google spreadsheet integration, which means you now have 4 different spreadsheets.
2. We will then use conditional logic to redirect the user to the specific form that has Google spreadsheet integrations on them. Here's a guide that you can refer to: http://www.jotform.com/help/317-Configuring-Change-Thank-You-URL-after-submission-condition
Here's a sample condition, it states that if the drop down field is equal to "Spreadsheet 1" then redirect the user to my Form 2's URL.
Repeat the same process on the other spreadsheet options.
I hope that helps.
Thank you, I'm going to try this
In my colleague's name, you are welcome. Please do let us know if you have any issues or questions along the way and we would be happy to answer them.