Google Apps Script - triggered onEdit(e) with onEdit and oChange, both returned same error.
TypeError: Cannot read property 'range' of undefined code 6 ie; e.range
function onEdit(e) {
var range = e.range;
var spreadSheet = e.source;
var sheetName = spreadSheet.getActiveSheet().getName();
var row = range.getRow();
if(sheetName == 'DATA')
{
var new_date = new Date();
spreadSheet.getActiveSheet().getRange(row,6).setValue(new_date).setNumberFormat("MM/dd/yyyy hh:mm:ss A/P");
}
}
`
Using SpreadSheet with 6 columns, the Col6 (F) for update (MM/DD/YYYY hh:mm:ss A/P) triggered with onedit. Tried necessary changes on colA to colE, but Col6 (F) not updating the for any changes.
Please note: for empty cell running the script, property return error due to "null" value is understood. But here even the changes made on SS does not return the UPDATE on col6(F). Kindly HELP