google-apps-script - Send notification to specific email from column M only when value 1 in column L is chosen

Question

我希望我的工作表向 M 列中选择的邮件发送通知，但仅当在 L 列中选择值 1 时。

样本表：https ://docs.google.com/spreadsheets/d/1wLd5mXAKQ7pWfo5_ZOSkbtvORfFcnAkg17TSZgN73jM/edit?usp=sharing

标签： google-apps-scriptgoogle-sheetsemail-notifications

Answer 1

尝试这个：

function onEdit(e) {
  var sh=e.range.getSheet();
  if(sh.getName()!='Ark1')return;
  if(e.range.columnStart=12 && e.value==1) {
    var subject="Whatever";
    var body="Whatever";
    GmailApp.sendEmail(e.range.offset(0,1).getValue(), subject, body)
  }
}