如果在谷歌工作表上编辑F6,以下内容将发送电子邮件通知。如果F列中的任何单元格被编辑,而不仅仅是一个单元格,我需要帮助它发送通知。我试过('F6,F7等),我试过F:F,这些都不管用。
function emailNotification(e) {
var sheet = e.source.getActiveSheet();
if (sheet.getName() !== 'Sheet1' || e.range.getA1Notation() !== ('F6')) return;
return;
var recipient = "mail@google.com";
var subject = 'SUBJECT';
var body = ' BODY OF MAIL ';
MailApp.sendEmail(recipient, subject, body);
};
请帮帮我,我不知道哪里出了问题。否则,脚本就像一个单元格的魅力。只是不是整列
如果Sheet1的F列中的任何单元格被编辑,这将运行代码。
function onEdit(e)
{
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var sheetName= sheet.getSheetName();
if(sheetName=="Sheet1"){
var editRange = sheet.getActiveRange();
var editRow = editRange.getRow();
var editCol = editRange.getColumn();
var lr = sheet.getLastRow()
var range = sheet.getRange("F1:F"+lr);
var rangeRowStart = range.getRow();
var rangeRowEnd = rangeRowStart + range.getHeight()-1;
var rangeColStart = range.getColumn();
var rangeColEnd = rangeColStart + range.getWidth()-1;
if (editRow >= rangeRowStart && editRow <= rangeRowEnd
&& editCol >= rangeColStart && editCol <= rangeColEnd)
{
Logger.log("Run Code")
//YOUR CODE HERE
}}}