onFormSubmit（）触发器是否可以由人类提交Google表单以外的其他内容触发？(Can onFormSubmit() trigger be triggered by something el

onFormSubmit（）触发器是否可以由人类提交Google表单以外的其他内容触发？(Can onFormSubmit() trigger be triggered by something else other than a human submitting a Google form?)

我有一个Google表单，它设置为在完成表单时发送电子邮件。 我非常接近http://www.labnol.org/internet/auto-confirmation-emails/28386/ ，主要是改变文本。 它确实发送了一个提交的电子邮件，万岁！

表格本身需要质疑，因此人们不应该在不填写至少那些问题的情况下提交表格。

然而，在周末（周日11日），发送了三封电子邮件，其中包含空白回复，甚至是所需的问题！

所以我认为有三种可能的解释：

所需的问题不起作用/形式的结构暂时错误，并允许来自人的三个空白回答。 某种机器人/爬行脚本以某种方式触发了空提交 表格由人完成，数据未记录，也未包含在电子邮件中。

这些解释中的任何/所有解释是否合理/看似合理？

如果3是答案，你知道这是在周日发生的短暂的，可能是文件记录的错误吗？

I have a Google form, it is set up to send emails on completion of the form. I followed http://www.labnol.org/internet/auto-confirmation-emails/28386/ pretty much exactly, just changing the text mainly. And it does indeed send emails on a submit, hooray!

The form itself has required questioned so a human shouldn't be able to submit the form without filling at least those questions in.

However, over the weekend (on Sunday 11th), three emails were sent with blank responses, even to the required questions!

So I think there are three likely explanations:

The required questions didn't work / structure of the form momentarily errored and allowed three blank responses from a human. Some sort of robot / crawling script somehow triggered a null submit The form was completed by a human and the data was not recorded, nor included in the email.

Do any / all of those explanations make sense / seem plausible?

And if 3 is the answer, do you know if it was a transitory, maybe documented, error that happened on Sunday?

最满意答案

我不明白为什么机器人无法提交谷歌表格。 onSubmit触发器就像听起来一样。 一旦提交表单，谷歌脚本就会运行，无论发送信息的内容是什么，只要它被提交到脚本将运行的表单。

此脚本检查电子邮件文本正文的空白数据，但没有其他内容。

我已对此进行了测试，并且可以确认即使您的Google表单根据需要设置了问题，如果它是文本或段落条目，那么您只需输入空格即可考虑有效数据。 所有表单提交都应存储在Google电子表格中，因此我建议您检查电子表格的响应，以查看该单元格实际上是空白还是包含“''等数据。

我个人总是在做自动回复时使用特定范围，或者我需要使用表单提交中的数据。 通常，数据应始终位于电子表格的相同位置。

只要提交表单，您的脚本就会运行。 因此，如果机器人可以绕过检查，如果问题为空并仍然提交它，那么您的脚本无论如何都会运行。

I do not see why a bot could not submit a google form. The onSubmit trigger is just as it sounds. As soon as the form is submitted the google script runs so regardless of what sends the information as long as it was submitted to the form the script will run.

This scrip does a check against blank data for the text body of the e-mail but nothing else.

I have tested this and can confirm that even if your google form has a question set as required, if it is a text or paragraph entry then all you have to do is enter space and it will consider that valid data. All form submissions should be stored on a google spreadsheet so I would recommend checking the spreadsheet responses to see if the cell is actually blank or if it contains data like ' '.

Personally I always use specific ranges when doing an auto response or if I need to work with data from a form submission. Generally data should always be in the same place on the spreadsheet.

Your script runs whenever a form is submited. So if a bot can bypass the check if question is empty and still submit it then your script will run anyway.