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 forward submissions from different forms into the same spreadsheetAsked by visitinspire on September 26, 2014 at 04:54 PM
Hi: I'm setting up a writing contest and I've got my form in place for the public who will be submitting their short stories. Now on the judging side, I have 5 judges who will be reading the articles and rating them. So far what I have done is create a form for each article that includes the story, so the judges can read it, then it has a 1-10 scale at the bottom where they can rate the story after they've read it. Because I have set up a new form for each article, and there could be as many as 50-75 articles, how can I get all the rating scores to go into the same spreadsheet? Otherwise, each story is a separate form with it's own spreadsheet--which is not very efficient. There must be a way for me to get multiple rating into the same spreadsheet.
We do not have an option to send the form data from multiple forms into the same Spreadsheet/Google Spreadsheet.
As a work around, it is possible to use a Zapier service integration to send the data from the jotform email alerts to online Google Spreadsheet.
Setup is the following:
- Create the next Zap on your Zapier account.
- Then, add an Email Notification to each rating jotform. The Email Notifications should be configured to use special Zapier email recipient address, so it will forward the data to your Google Spreadsheet.
Please feel free to contact us if you need any further assistance.