javascript - 在Google表格中按状态自动发送电子邮件

Question

以下代码第7行出现错误，var sheet = ss.getSheetByName(“Active Projects”);
项目完成后，将使用此代码发送电子邮件。

function checkValue(e) {
  var ss = SpreadsheetApp.getActive();

  var sheet = ss.getSheetByName(“Active Projects”);

  var valueToCheck = sheet.getRange(“E”).getValue();

  var rangeEdit = e.range.getA1Notation();

  if (rangeEdit == “E”)

  {

    if (valueToCheck = Completed)

    {

      MailApp.sendEmail(“0000 @gmail.com”, “blah”, “test” + valueToCheck + “.”);

    }

  }

}

Answer 1

尝试将智能引号(“”)更改为普通引号(""):

function checkValue(e) {
  var ss = SpreadsheetApp.getActive();

  var sheet = ss.getSheetByName("Active Projects");

  var valueToCheck = sheet.getRange("E").getValue();

  var rangeEdit = e.range.getA1Notation();

  if (rangeEdit == "E")

  {

    if (valueToCheck = Completed)

    {

      MailApp.sendEmail("0000 @gmail.com", "blah", "test" + valueToCheck + ".");

    }

  }

}