Multiple forms onto one spread sheet with multiple tabs

  • Profile Image
    benroetger
    Asked 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

  • Profile Image
    Kiran
    Answered 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!