我有一个 Google 表单，供现场工作人员填写并提交。附加的 javascript 将表单内容作为电子邮件发送给办公室中的每个人。

执行时间非常长。其中一个报告了 19496 秒，而 Gsuite 应该在 5 分钟后自动终止任何脚本。有些在 Google 应用脚本执行日志中显示“未知”状态，并且为 0 秒。

Gsuite 配额是否已用完？我的脚本中是否有错误？

运行脚本触发器的用户也会收到退回电子邮件，即使所有电子邮件都在发送，并且 Google 表格正在正常接收来自 Google 表单的响应。

我尝试在顶部添加“if(e.values && !e.values[1]){return;}”并在底部添加“return;”。这似乎并没有改变问题。

我编辑了下面的 Google 应用脚本，删除了电子邮件地址的实际列表，并缩短了报告。Google 表单的目的是提供他们一天工作的真实摘要，而不仅仅是电子邮件中的“工作已完成”。因此，他们填写了 15 个问题的列表。

function myFunction(e){

// Set values for event "e" from Response form, each number being a column in the spreadsheet 
    var value1 = e.values[1];
    var value2 = e.values[2];
    var value3 = e.values[3];
    var value4 = e.values[4];
    var value5 = e.values[5];


  // Build subject and message for email that will be sent out
    var subject1 = value5 + " Job #" + value2 + " " + value3 + " Job Report Submitted " + value1 + "    -oOo-";
        var message_html = "<b>Date:</b> " + value1 + "<br>" + 
                   "<b>Job Number:</b> " + value2 + "<br>" +
                     "<b>Site Name:</b> " + value3 + "<br>" +
                     "<b>Client:</b> " + value4 + "<br>" +
                       "<b>Crew Chief:</b> " + value5 + "<br>";            


     // Send email to chief, of what the chief submitted through the Response form
     var chiefemail = "[email protected]"; //setting leo email as the default - but this should not be used based on below 
     var chiefname  = "Leo E.";

     if (value5 == "Bryan N.") {
                                    chiefemail = "[email protected]";
                                    chiefname  = "Brian N";}
     else if (value5 == "Carl B.") {
                                    chiefemail = "[email protected]";
                                    chiefname = "Carl B";
                                   }
     else if (value5 == "Clay W.") {
                                    chiefemail = "[email protected]";
                                    chiefname = "Clay W";
                                     }
     else if (value5 == "Dakota P."){
                                    chiefemail = "[email protected]";
                                    chiefname = "Dakota P";
                                     }



 // Send emails to all office staff:     

   var EmailList = "[email protected]," + chiefemail; 


       MailApp.sendEmail({
                          to: EmailList,
                          subject: subject1,
                          htmlBody: message_html,
                          name: chiefname,
                          replyTo: chiefemail
                           });


}

我希望脚本终止，并且我不想收到退回的电子邮件。救命！