Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function dopuskator2() {
- const ss = SpreadsheetApp.getActive();
- const sh = ss.getSheetByName('убираем всех');
- const d = sh.getDataRange().getValues();
- d.forEach((g, i) =>{
- const [url, check, delAll, newOrder] = [g[0], g[1], g[2], g[3]];
- if(url && !check && (delAll || newOrder) && i > 0){
- const f = DriveApp.getFileById(getIdFromUrl(url));
- if(delAll){
- f.getEditors().map(g => f.removeEditor(g));
- f.getViewers().map(g => f.removeViewer(g));}
- if(newOrder){
- f.setSharing(DriveApp.Access.PRIVATE, DriveApp.Permission.NONE)}
- sh.getRange(i+1, 2).setValue(true);
- SpreadsheetApp.flush();
- }
- })
- }
- function getIdFromUrl(url) { return url.match(/[-\w]{25,}/); }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement