google-apps-script - Google Apps 脚本可根据另一个工作表中的单个 TRUE/FALSE 单元格清除范围

Question

我试图根据另一个工作表中单个单元格的真/假值清除 4 列数据的内容。这是我有史以来的第二个脚本。我尝试使用这两个引用文献中的一些示例:[Google Apps Script to clear multiple range] 和 i need a button to clear multiple ranges in a google spreadsheet . 2

我认为我没有正确调用触发单元的值。我希望脚本在此单元格的值发生更改时运行。这是我的代码:

function clearautocratFields(e) {

  /*  variables for the function: triggerCell: is contained in the 'Meet Ranges' sheet.  It is cell k2.  Can be TRUE/FALSE.
      dataSheet: is the sheet 'Form Responses 1'.  Thats where the cells are that I want to clear.
      The Ranges I want to change are 'fg2:fg, fh2:fh, fi2:fi, fj2:fj'*/

  var triggerCell = SpreadsheetApp.getActive().getSheetByName('Meet Ranges').getSheetValues('k', '2', 1, 1); 

  if (triggerCell == 'TRUE'){} else  // If the cell is true do nothing
  if (triggerCell == 'FALSE'){   // If the cell is false run the script



  var dataSheet = SpreadsheetApp.getActive().getSheetByName('Form Responses 1');// Range to clear
    sheet.getRange('fg2:fg').clearcontents();
    sheet.getRange('fh2:fh').clearcontents();
    sheet.getRange('fi2:fi').clearcontents();
    sheet.getRange('fj2:fj').clearcontents();
    }

}

Answer 1

`getSheetValues() 方法的语法是:

getSheetValues(startRow, startColumn, number of Rows, number of Columns)

startRow参数必须是整数。你有一个字符串。

getSheetValues('k', '2', 1, 1)