基于表单提交的Google脚本触发器

Question

我有一个简单的脚本，似乎只有当我编辑特定的领域，我正在寻找“在校园”。目前，我必须编辑一些不同的字段，然后将其更改为“在校园”之前，脚本将启动。

我想要的是，当表单提交时，如果指定的字段上写着“在校园”，我希望这个脚本启动。

知道为什么只有我手动编辑字段才能工作吗？我已将触发器设置为表单提交。

function sendEmailSupervisor(e) {
  if (e.range.columnStart != 11 || e.value != "On Campus") return;
  const rData = e.source.getActiveSheet().getRange(e.range.rowStart,1,1,21).getValues();
  let a = rData[0][0];
  let b = rData[0][1];
  let c = rData[0][4];
  let d = rData[0][5];
  let f = rData[0][6];
  let now = new Date().toLocaleString("en-US");
  
  let msg = "Date/Time Submitted: "+ a + "\n \n" + "Email Address:  " + b +  "\n \n" + "Person Requesting? " + c +  "\n \n" + "Name of the event? " + d +  "\n \n" + "Description of the event? " + f +  "\n \n" + " Form Submitted:  " + now;
  Logger.log(msg);
  GmailApp.sendEmail("myemail@mydomain.com", "On Campus Event Submitted", msg)
}

​

​

Answer 1

我不能测试这个，但它应该能用。

function sendEmailSupervisor(e) {
  Logger.log(e.values); // just so you can see what values are
  if( e.values[10] !== "On Campus" ) return;  // column K
  let a = e.values[0];
  let b = e.values[1];
  let c = e.values[4];
  let d = e.values[5];
  let f = e.values[6];
  let now = new Date().toLocaleString("en-US");
  
  let msg = "Date/Time Submitted: "+ a + "\n \n" + "Email Address:  " + b +  "\n \n" + "Person Requesting? " + c +  "\n \n" + "Name of the event? " + d +  "\n \n" + "Description of the event? " + f +  "\n \n" + " Form Submitted:  " + now;
  Logger.log(msg);
  GmailApp.sendEmail("myemail@mydomain.com", "On Campus Event Submitted", msg)
}