- jonnybodeAsked 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?
Jon BodePage URL:
- JotForm SupportChriistianAnswered on September 13, 2016 at 04:55 AM
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.