我的代码使用myFunction()
运行得很好,但是当我将其更改为onEdit
,并使用e.range
和列号恢复在特定列中的工作时,它停止了
function onEdit(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Timesheet & Feedback");
var cell = ss.getActiveCell();
var cellContent = cell.getValue();
var Manaf = CalendarApp.getCalendarById("manaf652@gmail.com");
var MustafaSmeer = CalendarApp.getCalendarById("8q65ner19m8uk8idmmkmrr2hvs@group.calendar.google.com");
var activeRow = ss.getActiveCell().getRow();
var data = ss.getRange("A" + activeRow + ":G" + activeRow).getValues();
var range = e.range;
var CellColumn = range.getColumn();
if (CellColumn == 2) {
if (cellContent === "Mustafa Sameer") {
MustafaSmeer.createEvent(data[0][0], data[0][2], data[0][2], {
description: "First call " + data[0][0]
});
MustafaSmeer.createEvent(data[0][0], data[0][4], data[0][4], {
description: "Second call " + data[0][0]
});
MustafaSmeer.createEvent(data[0][0], data[0][6], data[0][6], {
description: "Third call " + data[0][0]
})
}
}
};
https://stackoverflow.com/questions/56692181
复制相似问题