โจevent: onEdit
/**
* onOpen()
*/
function onOpen() {
// app UI
var ui = SpreadsheetApp.getUi();
// โฅ ่ช่ฃฝๅทฅๅ
ท
ui.createMenu('๐งฐ ๅทฅๅ
ท็ฎฑ')
.addItem('โถ ๅๅงๅ ฑ่กจ โ ็ๆ่ณๆ', 'init')
.addToUi();
}
/**
* onEdit(e)
* triggered when editing the spreadsheet.
* @param {Event} e The onEdit event.
*/
function onEdit(e) {
// โญ๏ธ edited cell
var range = e.range;
let rngGrade = App.range.byName('Grade');
// ไธๆฏใ้ซไธใ้ซไบใ้ซไธใ้ฃไธๆ ผ๏ผๅฐฑ่ซๅใ
if (!App.isSameRange(range, rngGrade)) return;
App.updateCurrentClasses();
}
Last updated