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.


  • Profile Image

    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?

     

    Thanks 

     

    Jon Bode

    Page URL:
    www.extraordinarykids.com.au

    use create love thanks hello
  • Profile Image
    JotForm Support

    Answered by Chriistian 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:

    Import Range: how do I use it? Instructions and tips
    Using IMPORTRANGE in Google Sheets

    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.
    Regards.