Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e){
- var curDate = Utilities.formatDate(new Date(), "GMT+01:00", "hh:mm");
- var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Test2');
- var colInicio = e.range.getColumn();
- var filaInicio = e.range.getRow();
- var ref = e.range.getA1Notation(); // Notation tipe A1 or A1:B2
- var range = e.range;
- var colIndex = colInicio.getColIndex();
- var rowIndex = filaInicio.getRowIndex();
- var watchRange1 = {
- top : 11, // start row
- bottom : 109, // end row
- left : 3, // start col
- right : 11, // end col
- };
- var watchRange2 = {
- top : 11, // start row
- bottom : 109, // end row
- left : 13, // start col
- right : 21, // end col
- };
- if(rowIndex >= watchRange1.top && rowIndex <= watchRange1.bottom &&
- colIndex >= watchRange1.left && colIndex <= watchRange1.rigth &&
- range.getValue() != 0){
- var DateCol1 = "K9"; //Cell you want to have the date
- SpreadsheetApp.getActiveSheet().getRange(DateCol).setValue(curDate);
- //Write the date in the cell
- }else if (rowIndex >= watchRange2.top && rowIndex <= watchRange2.bottom &&
- colIndex >= watchRange2.left && colIndex <= watchRange2.rigth &&
- range.getValue() != 0){
- var DateCol1 = "U9"; //Cell you want to have the date
- SpreadsheetApp.getActiveSheet().getRange(DateCol).setValue(curDate);
- //Write the date in the cell
- }else{
- //if test
- var DateCol1 = "K9";
- SpreadsheetApp.getActiveSheet().getRange(DateCol).setValue("Fallo");
- };
- }
Add Comment
Please, Sign In to add comment