How to split answers from different respondents into different Google tables?

M

Mikolay_Udalov2020-10-10 11:51:45

Google Apps Script

Mikolay_Udalov, 2020-10-10 11:51:45

Is it possible to make it so that when a person selects one option in a Google form, the data is entered into tables a, b and c, if the other is entered into tables a, c and g , for example. Roughly speaking, so that the answers are duplicated in different tables.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

M

Maxim Stoyanov, 2020-10-10
@stomaks

Yes, you can, as the simplest of the options is:
Save the results to a Google spreadsheet (standard option). And then extract the necessary data from it using the QUERY () formula.
---
Maxim Stoyanov (stomaks), developer of Google Apps Script .
g-apps-script.com
stomaks.me

A

Alexander, 2020-10-11
@ForestAndGarden

Addition to the answer given by Maxim Stoyanov : How to move a line to another sheet by condition?