Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- if ([1, 2,].indexOf(e.range.columnStart) != 1) return;
- createEmployeeFolder();
- }
- function createEmployeeFolder() {
- var parent = DriveApp.getFolderById("1H0i69rE9WO0IAoxhnrFY2YKT_tD50fuX")
- SpreadsheetApp.getActive().getSheetByName('Database').getRange('B3:B').getValues()
- .forEach(function (r) {
- if(r[0]) checkIfFolderExistElseCreate(parent, r[0]);
- })
- }
- function checkIfFolderExistElseCreate(parent, folderName) {
- var folder;
- var idfolder;
- var link;
- try {
- folder = parent.getFoldersByName(folderName).next();
- } catch (e) {
- folder = parent.createFolder(folderName);
- idfolder = folder.getId();
- link = folder.getUrl();
- formula = '=hyperlink("' + link + '",' + folder + ')';
- SpreadsheetApp.getActive().getSheetByName('Database').getRange('B3:B').setFormula(formula);
- }
- }
Add Comment
Please, Sign In to add comment