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

    Multiple forms onto one spread sheet with multiple tabs

    Asked by benroetger on June 27, 2016 at 08:14 PM

    Hello,

     

    Currently i have one form which is integrated onto a google spreadsheet.

     

    Am i able to have multiple forms integrated onto one spread sheet but on separate pages

     

    for example

     

    Form 1 Data - found on sheet 1

    Form 2 Data - Found on sheet 2 

     

    etc

     

    etc

    sheet spread integrated hello one form
  • Profile Image
    JotForm Support

    Answered by Kiran on June 27, 2016 at 11:18 PM

    Do you mean to receive multiple form submissions into different sheets of a Google spreadsheet? If so, unfortunately, it is not possible to receive multiple form submissions to the same spreadsheet. When the Google spreadsheet integration is added to the form, it automatically creates a new sheet in your Google account. However, you may merge multiple forms data to a new spreadsheet by using IMPORTRANGE function in Google spreadsheets.

    Please refer to the web page below that can help you with using ImportRange function.

    https://support.google.com/docs/answer/3093340?hl=en

    http://www.makeuseof.com/tag/how-to-import-data-from-other-google-spreadsheets/

    Hope this information helps!