How to use the onEdit(e) Function on Google Sheets. This video focuses on edit in 1 cell.
The script in Video:
function onEdit(e) {
var range = e.range;
var spreadSheet = e.source;
var sheetName = spreadSheet.getActiveSheet().getName();
var column = range.getColumn();
var row = range.getRow();
var inputValue = e.value;
if(sheetName == 'ONEDIT' && column == 1 && row == 1)
{ SpreadsheetApp.getActiveSpreadsheet().getSheetByName('ONEDIT').getRange('A2').setValue([inputValue]);
}
}
Video, Code, and Documentation can also be found at:
codewithcurt.c...
Негізгі бет How to use the onEdit(e) Function on Google Sheets
Пікірлер: 73