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 do you get Google integration into just 1 spreadsheet?

    Asked by ben2028 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.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by jonathan on January 20, 2013 at 05:48 PM

    Hi,

    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.

    Thanks.

  • Profile Image

    Answered by on January 30, 2013 at 07:53 AM

    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.

  • Profile Image
    JotForm Support

    Answered by jonathan on January 30, 2013 at 09:34 AM

    Thank you for sharing this information. I will bookmark this and use for my reference.

    Thanks.