找到你要的答案

Q:Store Google Form Responses in 3 different spreadsheets depending on form choices

Q:根据表单选择在3种不同的电子表格中存储谷歌窗体响应

I have created a form in which students have to tell if they've formed a group of 4, 5 or 6 members and correspondingly fill out the email id's of all members in the group.
Right now, all the responses land in a single document, like this

I want that depending on the group size, 3 different spreadsheets be created. To say, All group of 4 responses in 1 spreadsheet, all group of 5 in one spreadsheet and all group of 6 responses in one spreadsheet. So 3 spreadsheets for the 3 group options. I was going through the web and I see its possible via App scripts but I couldnt figure out how. Any leads on this?

I have created a form in which students have to tell if they've formed a group of 4, 5 or 6 members and correspondingly fill out the email id's of all members in the group.
Right now, all the responses land in a single document, like this

I want that depending on the group size, 3 different spreadsheets be created. To say, All group of 4 responses in 1 spreadsheet, all group of 5 in one spreadsheet and all group of 6 responses in one spreadsheet. So 3 spreadsheets for the 3 group options. I was going through the web and I see its possible via App scripts but I couldnt figure out how. Any leads on this?

answer1: 回答1:

no need to use script for this which is not trivial to do and handle all possible errors.

instead simply use a combination of importRange and filter/query to the other spreadsheets from the master responses.

by using spreadsheet formulas your spreadsheets will always update correctly and instantly.

不需要使用脚本来处理和处理所有可能的错误。

而不是简单地结合使用importrange和过滤器/查询到其他电子表格从主反应。

通过使用电子表格公式您的电子表格将永远正确和即时更新。

answer2: 回答2:

The easiest way would be to use an installable trigger on the form which is called on form submission. Rather than using the default functionality of adding all responses to a "Form Responses" sheet, your script would then take the raw form data and add it to the appropriate sheet based on the group size.

最简单的方法是使用一个安装的触发称为表格的形式提交。而不是使用默认功能的所有响应添加到“表单响应”表,您的脚本将采取原始形式的数据,并将其添加到适当的表的基础上的组大小。

forms  google-apps-script  spreadsheet