javascript - 将多个工作表名称传递到数组中 Google App 脚本不适用于时间戳函数

Question

这个脚本中我遗漏了什么吗？当sheet_name的变量设置为单个工作表时，它工作得很好，当我将sheet_names更改为数组[“sheet1”，“sheet2”，“sheet3”，“sheet4”]时，它不会触发(编辑时)

function onEdit(e) {
  var COLUMN_TO_CHECK = [1,4,5]; // The columns to check if something is entered. (Columns A & B)
  var DATE_TIME_COLUMN = 13; // Where you want the date time stamp (Column C)
  var SHEET_NAME = ["User1", "User2", "User3"]; // Sheet you are working on

  var editedCell = e.range;
  var editedSheet = e.range.getSheet();
  if (editedSheet.getName() === SHEET_NAME) {
    if (COLUMN_TO_CHECK.indexOf(editedCell.getColumn()) != -1) {
      var allFilled = true;
      var editedRow = editedCell.getRow();
      for (var i in COLUMN_TO_CHECK) {
        if (editedSheet.getRange(editedRow, COLUMN_TO_CHECK[i]).getValue() == "") {
          allFilled = false;
        }
      }
      if (allFilled) {
        editedSheet.getRange(editedRow,DATE_TIME_COLUMN).setValue(new Date());
      }
    }
  }
}

Answer 1

editedSheet.getName() 是一个字符串。 SHEET_NAME 是一个数组。它们永远不会相等 (===)。

使用SHEET_NAME.indexOf(editedSheet) != -1，从Array.indexOf()开始如果不存在，将返回-1。

更新了代码(将 SHEET_NAME 复数为 SHEET_NAMES):

function onEdit(e) {
  var COLUMN_TO_CHECK = [1,4,5]; // The columns to check if something is entered. (Columns A & B)
  var DATE_TIME_COLUMN = 13; // Where you want the date time stamp (Column C)
  var SHEET_NAMES = ["User1", "User2", "User3"]; // Sheet you are working on

  var editedCell = e.range;
  var editedSheet = e.range.getSheet();
  if (SHEET_NAMES.indexOf(editedSheet.getName()) != -1) {
    if (COLUMN_TO_CHECK.indexOf(editedCell.getColumn()) != -1) {
      var allFilled = true;
      var editedRow = editedCell.getRow();
      for (var i in COLUMN_TO_CHECK) {
        if (editedSheet.getRange(editedRow, COLUMN_TO_CHECK[i]).getValue() == "") {
          allFilled = false;
        }
      }
      if (allFilled) {
        editedSheet.getRange(editedRow,DATE_TIME_COLUMN).setValue(new Date());
      }
    }
  }
}