Advertisement
Guest User

Untitled

a guest
Jan 19th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. function onEdit(e) {
  2. if(e.range.getGridId()==1378158428) {
  3. var range=e.range;
  4. var index_row=range.getRow();
  5. var index_column=range.getColumn();
  6. var ss = SpreadsheetApp.getActiveSpreadsheet();
  7. var st = SpreadsheetApp.getActiveSpreadsheet();
  8. var sheet_source = ss.getSheetByName("Приход");
  9. if(index_row>67)
  10. var sheet_target = st.getSheetByName("Чек(английский)");
  11. else var sheet_target = st.getSheetByName("Чек(студия)");
  12. var date = new Date;
  13. if(index_column>5&&index_row>3) {
  14. if(sheet_source.getRange(2, index_column).isBlank())
  15. sheet_source.getRange(2, index_column).setValue(date);
  16. sheet_target.getRange(9, 1).setValue(range.getValue());
  17. sheet_target.getRange(7, 1).setValue(sheet_source.getRange(index_row, 1).getValue());
  18. sheet_target.getRange(11, 1).setValue(sheet_source.getRange(2, index_column).getValue());
  19. sheet_target.getRange(11, 3).setValue(date.getHours()+':'+date.getMinutes()+':'+date.getSeconds());
  20. }
  21. var protection = range.protect().setDescription('Sample protected range');
  22. var me = Session.getActiveUser();
  23. protection.removeEditors(me);
  24. if (protection.canDomainEdit()) {
  25. protection.setDomainEdit(false);
  26. }
  27. }
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement