can i have multiple form's submissions get exported in a google spreadsheet

  • worldscen
    Asked on October 17, 2014 at 4:53 PM

    So if I had a spreadsheet with multiple "sheets" ,each one was pulling submissions from a different form on my account? is there a way to do this?

     

  • jonathan
    Replied on October 17, 2014 at 7:21 PM

    Hi,

    The Google Spreadsheet integration can be used one jotform at a time. The integration is equivalent to one sheet in the spreadsheet. 

    So no. Unfortunately it is just one spreadsheet only. Although it contains multiple sheet, the output of the integration will only result to one sheet -- which you can give name to during the integration setup.

    can i have multiple forms submissions get exported in a google spreadsheet Image 1 Screenshot 20

    You can assign a Folder name though. Which means you can collect all the spreadsheets into single folder.

    If you need to contain all the different sheet into single spreadsheet, you will need to do it manually using the Google spreadsheet application.

    That is by importing each of the sheets data from different spreadsheets into a single spreadsheet.

    There is an ImportRange function in Google spreadsheet that can do this.

    I found this article on the internet that described how to do the import range feature.

    Hope this help. Inform us if there is more we can help you with.

    Thanks!