CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-forms
s2000coder
s2000coder

Reputation: 941

Multiple Forms' Responses Linked to One Single Spreasheet (separate sheets)

I am wondering if it's possible to link multiple forms to one single spreadsheet but on separate sheets.

For example: I would like responses of "form 1" and "form 2" to be placed in "sheet 1" and "sheet 2" of "spreadsheet ABC" respectively.

I know you cannot do this in the current form interface. It would you this error "The selected document is already the destination for a form.Choose another destination". I am curious if you could do this through Google Apps Scripts (perhaps Forms Services).

Thanks in advance.

Upvotes: 1

Views: 4312

Answers (1)

wchiquito
wchiquito

Reputation: 16551

Personally I have several forms linked to the same spreadsheet on separate sheets.

When you create the forms should have the option:

Responses -> Change response destination

enter image description here

UPDATE

This functionality is available in the new Google Sheets. See: Choose a form response destination.

Upvotes: 4

Related Questions