将两种形式的结果放在一张电子表格的两张纸上 [英] Put results of two forms in two sheets of one spreadsheet

问题描述

我有一个用于接受和审查赠款申请的系统.有两种形式:

I have a system for accepting and reviewing grant applications. There are two forms:

1. 由申请者提交的带有资助申请的表格
2. 我发送给三位审阅者的表格，以评估拨款请求

我希望在一个电子表格中同时包含两种形式的结果:

I'd like to have the results of both forms in one spreadsheet:

表1列出了申请表中的数据(带有自动生成的序列号).

Sheet 1 lists the data from the application forms (with an auto-generated serial number).

第2页列出了所有应用程序的所有审阅数据(其中一列是所审阅的应用程序的序列号).

sheet 2 lists the data from all the reviews for all the applications (with a column for the serial number of the application that was reviewed).

我遇到了麻烦:

1-指定两个表单的结果都放在不同工作表的同一电子表格中.

1 - Specifying that both Forms' results go into the same spreadsheet, on different sheets.

2-将序列号添加到应用程序中，然后将相同的序列号添加到三个审阅者的结果中.

2 - Adding a serial number to the applications and then adding the same serial number to the results of the three reviewers.

有什么建议吗?

推荐答案

使用GAS不可能将两个Google Forms的数据直接插入到单个电子表格中而不涉及另外两个电子表格，因为现在Forms仅能够部署数据拥有电子表格，而GAS则不提供任何访问表格的服务.

It is impossible to insert data of two Google Forms directly to a single spreadsheet using GAS without involving another two spreadsheets, because now the Forms are able to deploy data only to own spreadsheet and GAS has no any service to access to the Forms.

这篇关于将两种形式的结果放在一张电子表格的两张纸上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！