Google Apps脚本-用户填写表单时运行javascript

问题描述:

我是Google Apps脚本的新手,需要帮助.我试图实现以下目标-

I am new to Google apps script and need help. I an trying to achieve the following -

设置触发器以使Google表单中的文本框失去焦点.此事件中的代码将是 A.获取文本框的值 B.设置文本框的值

Set a trigger for lost-focus of a textbox in google form. The code in this event will be A. Get the value of a textbox B. Set the value of a textbox

不幸的是,当前无法使用Google Apps脚本和Google表单来实现.可以通过提交表单来触发Apps脚本,但是它不能与用户浏览器中的表单交互.

Unfortunately this is not currently possible with Google Apps Script and Google Forms. Apps Script can be triggered by the submission of a Form, but it cannot interact with the Form in the users browser.

可以完全使用Apps Script(使用HTML)构建表单,这将使您可以完全控制用户体验,但是您将无法使用Google Forms提供的功能.

It is possible to build a form entirely in Apps Script (using HTML) which would allow you full control over the user experience, but you lose access to the functionality provided by Google Forms.