Google multiple form response to a common master sheet

Question

I have three Google forms, all have common fields. I need to submit responses from all three form to a common sheet.

Answer 1

Google forms only allow one linked form per sheet, but you can have a document with multiple tabs by changing the form's response destination.

There are a few ways to get around this.

You could have one document with 4 tabs, one for each form's response and another 'master' tab which uses an array formula to combine the responses, eg:

ARRAYFORMULA(FormOneResponses!A2:D ; FormTwoResponses!A2:D ; FormThreeResponses!A2:D)

This assumes that all of the forms have exactly the same fields in the same order, if this isn't the case you would need to either reorder the columns or use several array formulas. You can also use functions like 'SORT' and 'UNIQUE' on this data.

You could also store the data in the forms, then use google apps script's Form.getValues(timestamp) function at time intervals to grab the responses for each form, put them in the order you want and add to the end of a single spreadsheet.

Another way to do this would be to create three web forms (possibly with google apps script) and have all three append rows to the same sheet when the data is submitted.