Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- if(e.range.getGridId()==1378158428) {
- var range=e.range;
- var index_row=range.getRow();
- var index_column=range.getColumn();
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var st = SpreadsheetApp.getActiveSpreadsheet();
- var sheet_source = ss.getSheetByName("Приход");
- if(index_row>67)
- var sheet_target = st.getSheetByName("Чек(английский)");
- else var sheet_target = st.getSheetByName("Чек(студия)");
- var date = new Date;
- if(index_column>5&&index_row>3) {
- if(sheet_source.getRange(2, index_column).isBlank())
- sheet_source.getRange(2, index_column).setValue(date);
- sheet_target.getRange(9, 1).setValue(range.getValue());
- sheet_target.getRange(7, 1).setValue(sheet_source.getRange(index_row, 1).getValue());
- sheet_target.getRange(11, 1).setValue(sheet_source.getRange(2, index_column).getValue());
- sheet_target.getRange(11, 3).setValue(date.getHours()+':'+date.getMinutes()+':'+date.getSeconds());
- }
- var protection = range.protect().setDescription('Sample protected range');
- var me = Session.getActiveUser();
- protection.removeEditors(me);
- if (protection.canDomainEdit()) {
- protection.setDomainEdit(false);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement