任何方式来验证Google表单输入？ [英] Any way to validate a Google form input?

问题描述

我想收集并验证Google表单中的值（PIN）。该表单有2页，我希望验证可以影响表单导航：

• 如果PIN与N列中的值匹配答复表，继续到表格第2页 如果PIN不匹配，请勿继续。 b

  这可以通过Google Apps脚本完成吗？

  解决方案

  您无法创建这种类型的动态表单Google表单服务，因为表单输入过程中服务和脚本之间没有交互，除了表单提交之外。在多页面的情况下，脚本无法知道用户已经完成了一个页面并转到另一个页面。

  
  
  

  您可以使用HtmlService或UiService，通过编写自己的表单。

  
  

  I want to collect and validate a value (PIN) in a Google Form. The Form has 2 pages, and I'd like the validation to affect form navigation:

  • If PIN matched with a value in Column N of the response sheet, continue to page 2 of the form
  • If PIN not matched, Do not continue.

  Can this be done with Google Apps Script?

  解决方案

  You are not able to create this type of dynamic form using the Google Forms Service, because there is no interaction between the service and scripts during form entry, except upon Form Submission. In the case of a multi-page form, a script has no way to know that a user has completed one page and gone on to another.

  You could achieve this using the HtmlService or UiService, by writing your own form.

  这篇关于任何方式来验证Google表单输入？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！