OK my bad.
function onEdit(e) {
const ss = e.source,
sheet = ss.getActiveSheet(),
sheetName = sheet.getName(),
range = e.range,
row = range.getRow(),
column = range.getColumn(),
value = range.getValue(),
dataRow = sheet.getRange(row, 1, 1, sheet.getMaxColumns()).getValues()[0];
switch (sheetName) {
case ‘Приход’:
if (row > 1 && column == 10 && value) {
const sheetTo = ss.getSheetByName(‘Оплата’)
sheetTo.appendRow([new Date(), dataRow[6], ‘Газ’])
}
break;
}
}
When i check checkbox in google sheet interface action happens. But when i do check from app nothing works. No errors, nothing.