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

  • Profile Image
    Joelapa
    Asked 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 form, 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

  • Profile Image
    Charlie
    Answered 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
    Joelapa
    Answered 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
    ashwin_d
    Answered 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!