Google Apps Script-如果cell='yes'，使用onEdit运行脚本

Question

我很难理解谷歌应用程序脚本中的onEdit（）函数。

我有一个Google工作表，它有一个主选项卡和4个单独的选项卡，如果用户在任何单独工作表的“发送电子邮件”列中选择“是”，我需要它来发送电子邮件。我有一个函数可以很好地做到这一点，在调试器中，我将把它粘贴到这里：（我知道它可能会被简化/缩减：）

代码：

 function triggers() {
 //Hold all values of selected sheet
 var zy = holdingData.values;

 for (var j = 0; j < zy.length; ++j) {
     //Get the UI functions and store them in a variable, used for prompts later in the script
     var ui = SpreadsheetApp.getUi();

     if (zy[j][9] === 'Yes') {

         //Pull values for later use
         holdingData.selVals.push([zy[j][0], zy[j][1], zy[j][2], zy[j][3], zy[j][4], zy[j][5], zy[j][7], zy[j][23], zy[j][24], zy[j][25]]);

         //Pull Teacher email from Master column B
         holdingData.teacherEmail.push(holdingData.selVal[j][7]);

         //Assign email based on contents of column X
         if (holdingData.selVals[j][8].toLowerCase() === "miranda") {
             holdingData.counselorEmail.push("[e-mail]");
         } //.....Other cases after this, cut for length

         //Assign subject line for specified individual
         holdingData.subject.push("Referral: " + holdingData.selVals[j][0] + " " + holdingData.selVals[j][1]);

         //Store columns C,D, and E in 1 variable string for each student
         holdingData.actionsTaken.push(holdingData.selVals[j][2] + ", " + holdingData.selVals[j][3] + ", " + holdingData.selVals[j][4]);

         //Assign Email message contents for specified individual sheet
         holdingData.message.push("The referral submitted for " + holdingData.selVals[j][0] + " " + holdingData.selVals[j][1] + " has been completed. The following action(s) were taken: " + holdingData.actionsTaken[j] + ", Please email the member of the discipline team who handled the referral if you have any questions or concerns, at: " + holdingData.counselorEmail[j] + ".");

         //Prompt user to confirm they would like to send the emails
         var response = ui.prompt('Are you sure you would like to send emails to the selected staff memebers?', ui.ButtonSet.YES_NO);
         if (response === 'YES') {
             //Send Message to Referring teacher
             MailApp.sendEmail(holdingData.teacherEmailMir[j], holdingData.subjectMir, holdingData.messageMir);

             //Send Message to Counselor assigned to student
             MailApp.sendEmail(holdingData.counselorEmailMir[j], holdingData.subjectMir, holdingData.messageMir);
         } else {return;}
     }
 }

}

我剪掉了一些长度，但我想做的核心就在那里。如果我用onEdit（）包装整个事情，它就不起作用了。如果我应用OnEdit（）作为一个简单的触发器（我相信），它将在每次编辑任何工作表时触发此脚本。我试过其他一些方法，但运气不好。我不明白什么？：）

Answer 1

什么都不会发生，因为您试图发送一封带有简单onEdit（）触发器的电子邮件。在这里的留档限制下，它甚至被作为一个例子

• 他们无法访问需要授权的服务。例如，简单触发器无法发送电子邮件，因为Gmail服务需要授权，但简单触发器可以使用匿名语言服务翻译短语