如何在谷歌表单中停止Onsubmit

How to stop Onsubmit in Google forms

本文关键字:Onsubmit 表单 谷歌      更新时间:2023-09-26

在谷歌表单中,我编写了一个验证检查,检查字段,如果超过计数,我需要停止表单提交并提醒用户错误。我可以将错误文本添加到div中,但无法停止表单提交。

如何停止表单提交。我试过e.preventDefault(),但没用。有人能帮忙吗。我已经附上了在谷歌表单提交事件中调用的代码。

function onFormSubmit(e) {
  Logger.log("test log", "testing");
var timestamp = e.values[0];
var programname = e.values[1];
var center = e.values[2];
var fullname = e.values[3];
var board = e.values[4];
var programtype = e.values[5];
var programobjective = e.values[6];
var calltoaction = e.values[7];
var begindate = e.values[8];
var enddate = e.values[9];
var marketing = e.values[10];
var budget = e.values[11];
var expectedparticipation = e.values[12];
var registrationfee = e.values[13];
var announcement = e.values[14];
var insightannouncement = e.values[15];
var additionallanguage = e.values[16];
var checklist = e.values[17];
var speakerprofile = e.values[18];
var noticeboarditem = e.values[19];
var toAddress = e.values[20];
var programcategory = e.values[21];
var liability = e.values[22];
var datesofannouncement = e.values[23];
var explaination = e.values[24];
var additionalquestion = e.values[25];
var location = e.values[26];
var externalpartners = e.values[27];
var intergenerational = e.values[28];
var announcementlanguage = e.values[29];
 // var app = DocumentApp.getUi();
  var app = UiApp.getActiveApplication();
  Logger.log("test log in checkAnnouncement: " + announcement + " insight " + insightannouncement, "testing");
 // var announcement = e.values[14];
  //var insightannouncement = e.values[15]; 
  //var toAddress = e.values[20];
  //var htmlBody = "Thank you for your <b>Program Package</b> report submitted on <i>";
  //var subject = "test subject";
  Logger.log(announcement, "testing");
  Logger.log(insightannouncement, "testing");
 // Logger.log(toAddress, "testing");
  announcement = announcement.replace(/(^'s*)|('s*$)/gi,"");
  announcement = announcement.replace(/[ ]{2,}/gi," ");
  announcement = announcement.replace(/'n /,"'n");
  insightannouncement = insightannouncement.replace(/(^'s*)|('s*$)/gi,"");
  insightannouncement = insightannouncement.replace(/[ ]{2,}/gi," ");
  insightannouncement = insightannouncement.replace(/'n /,"'n");
  if(announcement.split(' ').length > 3)
  {
     app.getElementById('entry_15').setText("*Announcement should be less than 30 words").setStyleAttribute("color", "#F00");
     e.preventDefault(); 
  }
  else if(insightannouncement.split(' ').length > 5)
  {
    app.getElementById('entry_32').setText("*insightAnnouncement should be less than 50 words").setStyleAttribute("color", "#F00");
   e.preventDefault(); 
  }
}

Google Forms的数据验证仅限于提交后,例如调用onFormSubmission触发器时。在这个时间点上,没有能力与Form UI交互。

触发器函数接收的Event是一个FormResponse对象,它不包含preventDefault()方法。

参考文献

  • 使用容器特定的可安装触发器
  • 了解事件
  • 类FormResponse

假设以上答案正确,并且此事件触发提交后,它们在技术上是正确的,您不能停止提交,但您可以从表单的集合中删除响应(如果我正确理解API的这一部分,则应将其删除。