-
benroetgerAsked on June 27, 2016 at 8: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
-
Kiran Support Team LeadReplied 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!