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.
Import the data from 4 integrated sheets into a 5th google spreadsheet.Asked by jonnybode on September 13, 2016 at 01:55 AM
Hello I love your service. I have 4 schools and 4 forms Monday tuesday wednesday thursday.
I have a google sheet for each form but i would also like to have a master copy with all of the enrolments. In essence i would like to create 5 sheets for 4 schools with one of the sheets being a copy of everyone's information so i can email all of the students at once. I don't want to use mail chimp because of the double opt in. Is there any other possibility?
Hello John and thank you for your feedback. I believe you can achieve your requirement by using the ImportRange function of google sheets. With this function, you can simply create the 5th form and add the importrange function there to import the data from the 4 other integrated google sheets. Here are a couple of guides that you can check out:
Alternatively, you choose to install the free "Import Sheet" add-on to automatically import the data from your other sheets into the 5th google sheet. Here's the link: https://importsheet.com/
Please let us know if you need further assistance.