google calculation calculation – Celda in the list of modifications of modification of real row of cells

If you want to create an automatic copy, it is recommended to automatically change the name of the player, the reading of the content, the content, the content and the form of the script, as well as the contents of the script, the procedure for creating the script, the script creation procedure, the contents of this script, the content of this script as well as the accuracy of the display.

function onEdit (e) {
var DateCol = "K8";
var curDate = Utilities.formatDate (new Date (), "GMT + 1", "dd / MM / yyyy")
var sheet = SpreadsheetApp.getActiveSpreadsheet (). getSheets ()[0];
var range = sheet.getRange (& # 39; C11: K18 & # 39;);
range.activate ();
var rowIndex = range.getRowIndex ();
var colIndex = range.getColumnIndex ();

// It may be necessary to configure several tracks of this type and check all tracks if
// checked fields are not in adjacent cells
var watchRange = {// B2: G20
top: 1, // starting line
bottom: 150, // end of the line
left: 1, // start col
right: 300, // end collar
};
// quit if we are out of range
if (rowIndex < watchRange.top || rowIndex > watchRange.bottom) return;
if (colIndex < watchRange.left || colIndex > watchRange.right) return;

var currentValue = range.getValue ();
currentValue = currentValue.replace (/ ^  s + |  s + $ / g, ""); // "trim" kludge

if (currentValue.length == 0) {

// Set a column to display the latest date of editing
SpreadsheetApp.getActiveSheet (). GetRange (DateCol + rowIndex) .setValue ("Edited:" +
CURDATE);
SpreadsheetApp.getActiveSheet (). GetRange (DeletedColNote + rowIndex) .setValue ("");

}
}

Gracias, a saludo