- ben2028Asked on January 20, 2013 at 02:39 PM
When I currently use Google integration, all my different forms are going into different spreadsheets. Instead of using 20 different spreadsheets with 1 page each, is there any way I can have just 1 spreadsheet with 20 different pages?
Your help would be greatly appreciated.
- JotForm SupportjonathanAnswered on January 20, 2013 at 05:48 PM
Currently, each google doc integrated form will equate to one spreadsheet only.
The suggested means to organize all the spreadsheet into group is, put them all in the same folder name when you integrate them.
Every time you do the process of integration, it will always ask for the folder location, -- this is the time you can specify which folder you wanted the form located.
BUT if what you wanted to do is combine all the spreadsheets into one spreadsheet with several sheets, you will have to do it manually every time.(transfer the updated spreadsheets sheet into that 1 big spreadsheet).
I did some google search for something automated incorporation of multiple spreadsheet into one. I found this tip. You may want to try if you can apply it in your spreadsheets.
Hope this help. Please inform us if you have further inquiry on JotForm.
An easier way to import multiple spreadsheets into ONE spreadsheet is to use the Google spreadsheet function, ImportRange, see http://docs.google.com/support/bin/answer.py?hl=en&answer=98757.
You can place this function anywhere in the new, summary sheet. I place the import for the first sheet about 5 rows down from the top. I estimate the maximum number of rows to be occupied by the first import and repeat the import for a second sheet about 5 rows lower than that estimate. I use the free rows to do calculations, sumif, conditional formatting etc.
I regularly use this function to combine two sheets into one. However, you could set up your summary workbook and use this function to import the individual Jotform sheets into their individual tabs, placing the appropriate worksheet name in an ImportRange function in each sheet.
- JotForm SupportjonathanAnswered on January 30, 2013 at 09:34 AM
Thank you for sharing this information. I will bookmark this and use for my reference.