- worldscenAsked on October 17, 2014 at 04: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?Page URL:
- JotForm SupportjonathanAnswered on October 17, 2014 at 07:21 PM
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.
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.