How to use the onEdit(e) Function on Google Sheets

Описание к видео How to use the onEdit(e) Function on Google Sheets

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:
https://codewithcurt.com/how-to-use-t...

Комментарии

Информация по комментариям в разработке