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.
Two Forms, One Google Spreadsheet?Asked by amgille on January 30, 2014 at 03:10 PM
We have two separate forms that we are creating for a program, one for applicants and another for references. We were wondering if when we created a spreadsheet for one, we might make the other another tab within that same spreadsheet.
Hi, if both forms have the same fields, you could integrate Google Spread in one form, then clone it and change the tittle of the cloned form. In that way you will be getting all the data from both forms into one spreadsheet.
Unfortunately the two forms do not have the same fields. For example, we have students input email addresses of the people who would be submitting recommendations for them (currently designed on a separate sheet). Would it be possible to send emails to those individuals using the conditions button with the separate form that could then be added to the other information on the spreadsheet?
Sounds like you want to send emails to the referrees automatically, then have them fill out a form which automatically updates the existing integrated google spreadsheet, right?
Well unfortunately, it is not possible to do that with current jotform features.
Automation of such a workflow would also be a bit difficult, and prone to errors.
I would advice that you export the referee data once submitted manually import it to Google Spreadsheet.
I will brainstorm this with the support team and update this thread.
Please advice us with the general workflow so that we may understand the bigger picture.