从Google Spreadsheet填充Google Form响应 [英] Populate a Google Form responses from a Google Spreadsheet

问题描述

我正在尝试(但目前还没有成功)使用我从本网站获取的内容以及Mogsdad提供的极为有用的答案此脚本的Google表单上列中的数据准备好回答问题了.这样会影响提交时自动提交所需的触发器吗?

我想补充一点，我对此的理解还很有限，因此，如果这样做似乎很容易，请走开！

解决方案

是否可以仅记录最后一个条目并使用它生成URL?

我不确定我是否在这里关注您-在另一个答案中，Logger.log()语句只是为了证明您可以分发正确的URL(如果要分发它).不用记录它，您只需使用变量url的内容即可.

但是，让我们继续前进，因为我认为这有点偏离您的发展方向.

然后，一旦填充了数据，预先填写的URL是否有可能自动提交?

有一个更好的起点. 我们可以通过编程方式将电子表格中的信息提交到Google表单中吗?当然可以！请参见使用应用脚本打开表单并进行选择.与您在"URL技巧"中看到的相比，这是一种更可靠的工作方式.

在自动提交"或模拟表单提交的情况下，您完全不必担心预先填写的URL.对于讨厌的人来说，这是捷径.您想要的是将payload组合为一个POST请求，而让计算机完全绕过表单UI.

关于Excel的事情...这会影响提交时自动提交所需的触发器吗?

(听起来像...)您正在使用Form1将数据获取到Spreadsheet1中，然后希望通过将数据从Form1中分离出来后让计算机提交Form2来对Form1的(人类?)提交做出反应.

是的，在尝试阅读信息以提交Form2之前，您需要小心完成列拆分.

我建议您最好使用Spreadsheet1的表单提交触发功能，该功能将拆分从Form1接收的字符串，然后立即将POST发送到Form2.然后，我将使用电子表格电子邮件触发器中的技术记录该操作已发生的事实. a>.

I am trying (and not succeeding at the moment) to populate a Google Form from a Google Spreadsheet using the items that I have picked up from this website and this extremely useful answer provided by Mogsdad here.

Ideally, I'm looking for:

1. The Logger.log (URL) logs URL's for all the data stored in the spreadsheet, is it possible to just log the last entry and use this to generate the URL?

2. Is it then possible for the pre-filled URL to auto submit once populated with the data? I have found this useful article here which suggests that this can be done?

3. The data that is stored in the Google Spreadsheet is data captured from another Google Form. This is due to the need of using Excel (lack of Internet connectivity) with a concatenate formula to merge all cells with data into one. This is then submitted on the other Google Form which has this script to split the data out by column ready to answer the questions with. Will this impact the trigger needed to auto submit when a submission is made?

May I add that I have a rather limited understanding on this so please go easy if this seems rather easy to do!

解决方案

is it possible to just log the last entry and use this to generate the URL?

I'm not sure I follow you here - in that other answer, the Logger.log() statement was just to demonstrate that you could generate the correct URL, if you wanted to distribute it. Instead of logging it, you'd just use the content of the variable url.

But let's move on, because I think this is a little off your path.

Is it then possible for the pre-filled URL to auto submit once populated with the data?

There's a better starting point. Can we programmatically submit information from a spreadsheet into a google form? Sure! See Use App Scripts to open form and make a selection. It's a more reliable way to do the job than what you see in the "URL Tricks" post.

In the case of "auto submit", or simulating a form submission, you don't need to worry about the pre-filled URL at all. That's a shortcut for pesky humans. What you want is to put together the payload for a POST request, instead, and have a computer bypass the form UI altogether.

Something about Excel... Will this impact the trigger needed to auto submit when a submission is made?

(Sounds like...) You are using Form1 to get data into Spreadsheet1, then expecting to react to the (human?) submission of Form1 by having the machine submit Form2 after breaking apart the data from Form1.

Yeah, you'll need to be careful that the column split is done before you try to read the information to submit Form2.

I suggest that you would be best served with a form-submission trigger function for Spreadsheet1 that splits the string received from Form1 then immediately sends the POST to Form2. I'd then record the fact that this action has occurred, using the technique from Spreadsheet Email Trigger.

这篇关于从Google Spreadsheet填充Google Form响应的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！