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

    How to create multiple google sheets with data from 1 form?

    Asked by Joelapa on July 27, 2016 at 12:53 AM

    I've set up a Jotform for collecting details on new staff starting employment at my company. I would like to create 2 google sheets: 1 with general information on them (taken from form) Home address, qualifications etc, the second sheet with emergency information of theirs (emergency contact, allergies etc). All these are fields on the form.

    I've tried google sheet integration and am able to get 1 Gsheet when I set up the integration. How to create another one and customize the fields it takes from the Jotform?

    Help your be much appreciated.

    Cheers

    Joel

    create how 1 form how to create
  • Profile Image
    JotForm Support

    Answered by Charlie on July 27, 2016 at 05:14 AM

    When an integration is made to Google Spreadsheet, it only creates one active spreadsheet for that form. 

    However, there are ways on how to reference data from the main integrated Google Spreadsheet to another "sheet" or to another spreadsheet.

    Option 1: One spreadsheet but having multiple sheets. You have 1 Google spreadsheet, but you can create multiple sheets on it, if you want to reference data from one sheet to another, that is possible, here's an article that you can refer to: https://support.google.com/docs/answer/75943?hl=en 

     

    Option 2: If you want to reference the integrated Google Spreadsheet to ANOTHER Google Spreadsheet, then you can use the IMPORTRANGE function of Google. Here's an article you can refer to: https://support.google.com/docs/answer/3093340?hl=en 

     

    I hope that gives you an idea on how to proceed.

  • Profile Image

    Answered by Joelapa on July 29, 2016 at 02:43 AM

    Hi Charlie, 

    Thanks for getting back to me straight away with that advice. What I ended up doing was creating a tab in the google sheet and transposing that information over. Simple fix!


    Cheers

    - Joel

  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 29, 2016 at 03:32 AM

    Hello Joel,

    On behalf of my colleague, you are welcome. 

    I am glad that you you were able to create achieve your requirement by adding additional sheet / tab in your google spreadsheet. Please ensure that you do not make any changes in the first sheet / tab of your integrated google spreadsheet. Please note that changing the heading column of google spreadsheet will cause the integration to break.

    Thank you!