Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. function onEdit(event)
  2. {
  3. var timezone = "GMT+1:00";
  4. var timestamp_format = "HH:mm dd/MM/yyyy"; // Timestamp Format.
  5. var updateColName = "Part No.";
  6. var timeStampColName = "Raised";
  7. var sheet = event.source.getSheetByName('Fill in List'); //Name of the
  8. sheet where you want to run this script.
  9.  
  10.  
  11. var actRng = event.source.getActiveRange();
  12. var editColumn = actRng.getColumn();
  13. var index = actRng.getRowIndex();
  14. var headers = sheet.getRange(1, 1, 1,
  15. sheet.getLastColumn()).getValues();
  16. var dateCol = headers[0].indexOf(timeStampColName);
  17. var updateCol = headers[0].indexOf(updateColName); updateCol =
  18. updateCol+1;
  19. if (dateCol > -1 && index > 1 && editColumn == updateCol) { // only
  20. timestamp if 'Last Updated' header exists, but not in the header row
  21. itself!
  22. var cell = sheet.getRange(index, dateCol + 1);
  23. var date = Utilities.formatDate(new Date(), timezone, timestamp_format);
  24. cell.setValue(date);
  25. }
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement