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.
Integrate only part of a form to a new sheetAsked by mshazelwood on August 13, 2016 at 11:00 PM
I'm making a form where teachers have to fill out some information about a list of students. What I really want is for each teacher to be able to submit the form, and have each form create a Google Sheet with a separate list of students.
For instance: the directors are submitting a list of students auditioning for a band. There will be many directors, and each director will have multiple students that they need to list all at one time so they don't have to just sit and resubmit forms over and over and over again. However, the person that needs to collect the information needs only to know which director submitted it, and then the list of details about each student (name, email, phone, instrument, etc).
I'm hoping for a way to have each submission create a new Google Sheets file, but the header rows would all be the same because the questions are all the same.
Does anyone have any ideas?
integrate sheet part a
Unfortunately, it's not possible to create a separate google spreadsheet for every student in record that was submitted. It is also not possible to create a separate spreadsheet since the spreadsheets integrated are on a per-form basis. So all submissions are collected to one spreadsheet only.
Hope this clarifies some concerns.
If you have other questions, please let us know.
Question - Is it possible, then, to have only PART of a form (the student info part) go to a Google Sheet?
It would not be possible. All data that is submitted to your form are then forwarded to Google Spreadsheet.
An alternative solution to this is then to split your forms in two. On the 1st form, place there the rest of the information and on the 2nd part, the student info part. Then just integrate to Google Spreadsheets your student info form.
So what will happen is that the 1st form gets filled up, then submitted, then replace your thank you page to redirect instead to the 2nd form for filling up of the student info, and submit again.
Non-Google Spreadsheets Solution
But if it's not necessary that it is going to be Google Spreadsheets, let's say downloading the Excel from JotForm's submissions, you can filter out the fields you want to appear on the Excel.
Another alternative also is creating a grid report of your submissions, you can also choose which fields should appear in your report. You can refer to this link for learning how to create reports: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm
If you have questions, please let us know.
I was also looking for a solution to only copy important sections to be pasted in a master report. This is easy to do in MS Excel but I'm forcing myself to learn and use more of Google Sheets.
Here's my scenario:
I have a Google Sheets integrated worksheet for all of my submissions and I have another worksheet with the automated scripts. Since I can't incorporate the one with the script to my database, I will copy sections of my database to my script sheet.
I found this wonderful solution and it just made my day.
Hoping that it will meet your requirements and make your day as well :)
Happy data manipulating.
- Randy, fellow JotForm user