Guest User

Untitled

a guest
Jun 22nd, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. function onEdit(e) {
  2. if ([1, 2,].indexOf(e.range.columnStart) != 1) return;
  3. createEmployeeFolder();
  4. }
  5.  
  6. function createEmployeeFolder() {
  7. var parent = DriveApp.getFolderById("1H0i69rE9WO0IAoxhnrFY2YKT_tD50fuX")
  8. SpreadsheetApp.getActive().getSheetByName('Database').getRange('B3:B').getValues()
  9. .forEach(function (r) {
  10. if(r[0]) checkIfFolderExistElseCreate(parent, r[0]);
  11. })
  12. }
  13.  
  14. function checkIfFolderExistElseCreate(parent, folderName) {
  15. var folder;
  16. var idfolder;
  17. var link;
  18. try {
  19. folder = parent.getFoldersByName(folderName).next();
  20. } catch (e) {
  21. folder = parent.createFolder(folderName);
  22. idfolder = folder.getId();
  23. link = folder.getUrl();
  24. formula = '=hyperlink("' + link + '",' + folder + ')';
  25. SpreadsheetApp.getActive().getSheetByName('Database').getRange('B3:B').setFormula(formula);
  26. }
  27. }
Add Comment
Please, Sign In to add comment