View difference between Paste ID: 4fUPV829 and CVZNxkKv

 /*
 Doc creator script : it allows to create a doc every working day by copying a chosen template. All copies are renamed with the date appended to the template name and are in the same original folder.
-UserProperties version to allow multiUser on one single deplOyed version
+V2 with mail notification & popups + recursive folder display - Using getFilesByType(DocsList.FileType.DOCUMENT) to try speeding up the app launch...
 Added the possibility to see the current process (triggers HAVE to be created with this version where the names are stored along with triggers ID)
-Doc creator script : it allows to create a doc every working day by copying a chosen template. All copies are renamed with the date and are in the same original folder.
+Added ability to test create on weekend !!
-Serge Gabet aka serge Insas september-10-2013 **Google Apps Script**
+UserProperties version to allow multiUser on one single deployed version
 Serge Gabet aka serge Insas september-12-2013 **Google Apps Script**
   */
 
-var btnAttributes = {'padding':'3px','font-family':"Arial, sans-serif",'fontSize':'10pt','border-radius':'4px'}
+
 var popAttributes = {'padding':'10px','font-family':"Arial, sans-serif",'fontSize':'14pt','color':'#000099','background':'#ffffee','border-radius':'10px'}
 var btnAttributes = {'padding':'6px','font-family':"Arial, sans-serif",'fontSize':'10pt','border-radius':'6px'}
 
-  var folderlist = new Array();
+
-  var folders=DocsList.getFolders()
+  var folderlist = []
-  for(var ff=0;ff<folders.length;++ff){
+  var allFolders = listFolders();
-    folderlist.push(folders[ff].getName());
+  for(var ff=1;ff<allFolders.length;++ff){
     Logger.log(allFolders[ff][1]);
     var folder = DocsList.getFolder(allFolders[ff][1]);
-  var Apanel = app.createAbsolutePanel().setSize('100%', '100%').setStyleAttribute('background', 'dedeff')
+    try{
     Logger.log('editors : '+folder.getEditors());// check if you have edit rights on this folder, if not > don't show in the list
     folderlist.push(allFolders[ff][1]+' ('+allFolders[ff][3]+' docs)');
-  var Flist= app.createListBox(false).setName("Flb").setId("Flb").setVisibleItemCount(12).setWidth("180");
+    }catch(err){}
-  var Dlist= app.createListBox(false).setName("Dlb").setId("Dlb").setVisibleItemCount(12).setWidth("280");
+
   var app = UiApp.createApplication().setTitle("AutoDocCreator");
   var Apanel = app.createScrollPanel().setSize('100%', '100%').setStyleAttribute('background', 'f5f5ff');
-  var Flab=app.createLabel('Folder List').setWidth("80");
+
-  var Dlab=app.createLabel('Document List').setWidth("100");
+
   var Flist= app.createListBox(false).setName("Flb").setId("Flb").setVisibleItemCount(12).setWidth("280");
-  Flist.addItem('Choose a folder').addItem('Root content');
+  var Dlist= app.createListBox(false).setName("Dlb").setId("Dlb").setVisibleItemCount(12).setWidth("350");
   var queryL = app.createLabel('Search in folder :');
   var query = app.createTextBox().setName('query').setId('query');
   var Flab=app.createLabel('Folder List (with edit rights)').setWidth("280");
   var Dlab=app.createLabel('Document List (text document only)').setWidth("350");
   Flist.addItem('Choose a folder').addItem('My Drive');
   for(ff=0;ff<folderlist.length;++ff){
     Flist.addItem(folderlist[ff]);
-  var chosen = app.createButton('Create a timer trigger for every day<br>at 00:00 from Monday to Friday').setId('chosen').setVisible(false).setStyleAttributes(btnAttributes).addClickHandler(waitHandler);
+
-  var cpanel = app.createVerticalPanel().add(choose).add(chosen);
+
   var docname = app.createLabel().setId('doc');
   var link = app.createAnchor('open ', 'href').setId("link").setVisible(false);
-  var grid = app.createGrid(5,3);
+
   var chosen = app.createButton('Create a timer trigger for every day<br>at 00:00 from Monday to Friday').setId('chosen').setVisible(false).setStyleAttributes(btnAttributes).addClickHandler(waitHandler);
   var testCreateHandler = app.createServerHandler('testCreateDocument').addCallbackElement(panel);
   var testCreate = app.createButton('Test create<br>the document',testCreateHandler).setId('testCreate').setVisible(false).setStyleAttributes(btnAttributes).addClickHandler(waitHandler);
   var seeHandler = app.createServerHandler('seeTrig');
   var killHandler = app.createServerHandler('killTrig');
   var seeTrig = app.createButton('See all current processes', seeHandler).setStyleAttributes(btnAttributes).setId('see').addClickHandler(waitHandler);
   var kill = app.createButton('Kill all current processes', killHandler).setStyleAttributes(btnAttributes).setId('kill').addClickHandler(waitHandler);
   var mailCheck = app.createCheckBox('send mail on doc creation').setId('mailCheck').setName('mailCheck').setVisible(false);
-      .setWidget(4,1,cpanel)
+  if(UserProperties.getProperty('mailCheck')=='true'){mailCheck.setValue(true)};
-      .setWidget(4,0,kill)
+  var grid = app.createGrid(8,3);
-      .setWidget(4,2,wait)
+
       .setWidget(1,0,Flist)
       .setWidget(0,1,Dlab)
-//
+
       .setWidget(2,0,queryL)
       .setWidget(3,0,query)
       .setWidget(2,1,docname)
       .setWidget(3,1,link)
       .setWidget(4,0,seeTrig)
       .setWidget(5,0,kill)
       .setWidget(5,1,choose)
       .setWidget(6,1,chosen)
       .setWidget(7,1,testCreate)
       .setWidget(6,0,mailCheck)
-  query.addKeyUpHandler(queryHandler)
+      .setWidget(7,0,wait);
   Apanel.add(panel.add(grid));
 
   var clihandler = app.createClientHandler()
      .forTargets(choose).setVisible(true)
      .forEventSource().setVisible(false);
    choose.addClickHandler(clihandler);
 
-  choose.addClickHandler(createTrigHandler)
+
-  chosen.addClickHandler(createTrigHandler)
+
   FHandler.addCallbackElement(panel);
 
   var queryHandler = app.createServerHandler("setTemplate");
-return app   ;  }
+  query.addKeyUpHandler(queryHandler);
   queryHandler.addCallbackElement(panel);
 
   var DHandler = app.createServerHandler("showlab");
   Dlist.addChangeHandler(DHandler).addClickHandler(waitHandler);
   DHandler.addCallbackElement(panel);
 
   var createTrigHandler = app.createServerHandler("createTrigger");
   choose.addClickHandler(createTrigHandler);
   chosen.addClickHandler(createTrigHandler);
   createTrigHandler.addCallbackElement(panel);
 
   app.add(Apanel);
-  var queryBox =app.getElementById('query')
+  return app;
 }
 
-  var folderName = e.parameter.Flb;
+function listFolders() {
-  if(e.parameter.source=='query'){queryBox.setText(e.parameter.query)}
+  var topFolder = DocsList.getRootFolder() ; // start point
   var foldersArray = [];
   foldersArray = getFolders(topFolder.getName().replace('Root','MyDrive'),topFolder,foldersArray);
   return foldersArray;
-  if (folderName!='Root content'&&query!=''){
+
-    doclist = DocsList.getFolder(folderName).getFiles(0,2000)
+
 function getFolders(path, container,arrayin) {
   var folders = container.getFolders(0, 300);
   var folderCount = folders.length;
-  } else if (folderName!='Root content'&&query==''){
+  var docCount = container.getFilesByType(DocsList.FileType.DOCUMENT).length;
-    doclist = DocsList.getFolder(folderName).getFiles(0,2000)
+  if(path=='MyDrive'){arrayin.push(['https://drive.google.com/?hl=fr&tab=wo#my-drive',path,folderCount])}
   else{arrayin.push([container.getUrl(),path.replace('MyDrive/',''),folderCount,docCount])}
   for (var i=0;i<folders.length;i++) {
     var thisFolder = folders[i].getName();
-  } else if (folderName=='Root content'&&query!=''){
+    var thisPath = path+"/"+thisFolder;
-    doclist = DocsList.getRootFolder().getFiles(0,2000)
+    getFolders(thisPath,folders[i],arrayin)
   }
   return arrayin;
 }
-  } else if (folderName=='Root content'&&query==''){
+
-    doclist = DocsList.getRootFolder().getFiles(0,2000)
+
   var app = UiApp.getActiveApplication();
   var wait = app.getElementById('wait').setVisible(false);
   var choose = app.getElementById("choose").setVisible(false);
   var chosen = app.getElementById("chosen").setVisible(false);
-  if(names.length==0){queryBox.setStyleAttribute('background','#ffaaaa')}else{queryBox.setStyleAttribute('background','#ffffff')}
+  var testCreate = app.getElementById("testCreate").setVisible(false);
   var Dlist = app.getElementById("Dlb");
   var doclist=new Array();
   var label = app.getElementById('doc');
   var names = new Array();
   var queryBox =app.getElementById('query');
-  UserProperties.setProperty('docInfos',names.toString());
+
   var doclist = new Array();
-  return app   ;// update UI
+  var folderName = e.parameter.Flb.substring(0,e.parameter.Flb.indexOf(' ('));// rip of the content counter ( xx docs)
   if(e.parameter.source=='query'){queryBox.setText(e.parameter.query)};
   if (folderName=='Choose a folder'){Dlist.clear();label.setText(" ");return app}
   if (folderName!='My Drive'&&query!=''){
     doclist = DocsList.getFolder(folderName).getFilesByType(DocsList.FileType.DOCUMENT);
     for (nn=0;nn<doclist.length;++nn){
       if(doclist[nn].getName().toLowerCase().match(query)==query){names.push([doclist[nn].getName(),doclist[nn].getId(),doclist[nn].getType()])}
     }
   } else if (folderName!='My Drive'&&query==''){
     doclist = DocsList.getFolder(folderName).getFilesByType(DocsList.FileType.DOCUMENT)
     for (nn=0;nn<doclist.length;++nn){
-  var docInfos = UserProperties.getProperty('docInfos').split(',');
+
     }
   } else if (folderName=='My Drive'&&query!=''){
     doclist = DocsList.getRootFolder().getFilesByType(DocsList.FileType.DOCUMENT)
     for (nn=0;nn<doclist.length;++nn){
-    var doctype = docInfos[docindex*3+2]
+      if(doclist[nn].getName().toLowerCase().match(query)==query){names.push([doclist[nn].getName(),doclist[nn].getId(),doclist[nn].getType()])};
     }
   } else if (folderName=='My Drive'&&query==''){
     doclist = DocsList.getRootFolder().getFilesByType(DocsList.FileType.DOCUMENT);
     for (nn=0;nn<doclist.length;++nn){
       names.push([doclist[nn].getName(),doclist[nn].getId(),doclist[nn].getType()]);
     }
-    var doclink = urlstring+docInfos[docindex*3+1]+poststring;
+
   if(names.length==0){queryBox.setStyleAttribute('background','#ffaaaa')}else{queryBox.setStyleAttribute('background','#ffffff')};
   names.sort();
-    var IDs = docInfos[docindex*3+1]+"|"+doctype;
+
   for(dd=0;dd<names.length;++dd){
     Dlist.addItem(names[dd][0]+" (doc Nr:"+dd+")");
-  return app   ;// update UI
+
   Logger.log(names.length);
   var html = app.createHTML('Only the 100 first items in '+folderName+' are shown<br>Use a folder to limit ').setStyleAttributes(popAttributes);
   var pop = app.createPopupPanel(true).setPopupPosition(150,280).add(html).setPixelSize(400,65).setStyleAttributes(popAttributes);
   Logger.log(names.length);
   if(names.length>100){names=names.splice(names.length-100) ; pop.show()};
   Logger.log(names.length);
   UserProperties.setProperty('docInfos',Utilities.jsonStringify(names));
   UserProperties.setProperty('folderName',folderName);
   return app;
 }
 
 
 function showlab(e){
   var app = UiApp.getActiveApplication();
   var wait = app.getElementById('wait').setVisible(false);
   var label = app.getElementById('doc');
   var link = app.getElementById('link');
   var choose = app.getElementById("choose").setVisible(false);
   var chosen = app.getElementById("chosen").setVisible(false).setEnabled(true);
   var testCreate = app.getElementById("testCreate").setVisible(false).setEnabled(true);
-                           '<br>(document name = <b>'+docN+'+ date</b>)<br>Use the button below to start the process');
+  var docInfos = Utilities.jsonParse(UserProperties.getProperty('docInfos'));
   if (e.parameter.Dlb!=""){
     var docname = e.parameter.Dlb
     var docN = docname.substr(0,docname.lastIndexOf("("));
     var docindex = docname.substring(Number(docname.lastIndexOf(":"))+1,Number(docname.lastIndexOf(")")));
     var doctype = docInfos[docindex][2];
     label.setText(doctype+" : "+docN).setEnabled(false).setStyleAttribute('fontSize', '15');
     if (doctype=='document'){var urlstring = "https://docs.google.com/document/d/";var poststring = "/edit"}
     if (doctype=='spreadsheet'){var urlstring = "https://docs.google.com/spreadsheet/ccc?key=";var poststring = "#gid=0"}
     if (doctype=='photo'){var urlstring = "https://docs.google.com/file/d/";var poststring = "/edit"}
     if (doctype=='blob_item'){var urlstring = "https://docs.google.com/file/d/";var poststring = "/edit"}
     if (doctype=='item'){var urlstring = "https://docs.google.com/file/d/";var poststring = "/edit"}
     var doclink = urlstring+docInfos[docindex][1]+poststring;
-      if (triggers[i].getUniqueId() == Existingtriggers[n]) {
+
     if(doctype=='document'){choose.setVisible(true)}else{choose.setVisible(false)};
-        Logger.log('deleted');
+    var IDs = docInfos[docindex][1]+"|"+doctype;
     UserProperties.setProperty('IDs',IDs);
   }
   return app;
 }
 
 
-  var html = app.createHTML('All triggers have been deleted, no document will be created anymore').setStyleAttributes(popAttributes)
+
-  var pop = app.createPopupPanel(true,true).setPopupPosition(150,300).add(html).setPixelSize(400,40);
+
   var wait = app.getElementById('wait').setVisible(false);
   var panel = app.getElementById('panel');
   var kill = app.getElementById('kill').setVisible(false);
   var IDs =  UserProperties.getProperty('IDs');
   var chosen = app.getElementById("chosen").setVisible(true);
   var testCreate = app.getElementById("testCreate").setVisible(true);
   var emailCheckHandler = app.createServerHandler('mailOption').addCallbackElement(panel);
   var mailCheck = app.getElementById('mailCheck').setVisible(true).addClickHandler(emailCheckHandler);
   if (e.parameter.source=='choose'){return app};
   var ID = IDs.substring(0,Number(IDs.lastIndexOf("|")));
   var doctype = IDs.substr(Number(IDs.lastIndexOf("|"))+1);
   var docname = e.parameter.Dlb
-                            +')<br>To stop this process simply re-run this application and choose the "kill all processes" option').setStyleAttributes(popAttributes)
+
-  var pop = app.createPopupPanel(true,true).setPopupPosition(150,300).add(html).setPixelSize(400,200);
+
   UserProperties.setProperty('docID',ID);
   var makeTrigger = app.createServerHandler('makeTrig').addCallbackElement(panel);
-  if(UserProperties.getProperties().toString().match('triggers')=='triggers'){
+
   var msg = app.createHTML('This document will be used as a template to create a new document every working day at 0 AM.'+
                            '<br>(document name = <b>'+docN+'+ date</b>)<br>Use the button below to start the process<br>and (un)check the email option as desired');
   var disableHandler = app.createClientHandler().forEventSource().setEnabled(false);
   var startProcess = app.createButton('Start process',makeTrigger).addClickHandler(disableHandler).setStyleAttributes(btnAttributes);
-  triggers.push(triggerID)
+
   Logger.log('createTrigger');
-  return app
+
 }
 
-function createDocument(){
+function mailOption(e){
-  var today = new Date().getDay();
+
   var mailCheck = e.parameter.mailCheck=='true';
   UserProperties.setProperty('mailCheck',mailCheck);
   var html = app.createHTML().setStyleAttributes(popAttributes)
   if(mailCheck){html.setHTML('A new mail will be sent on every working day around midnight with links to the 6 most recent documents created by this application.')}else{
-  var newDoc = DocsList.getFileById(docID).makeCopy(docName+Utilities.formatDate(new Date(),'EST','yyyy-MMM-dd'));
+    html.setHTML('No email will be sent')}
-  if(folderName!='Root content'){
+  var pop = app.createPopupPanel(true).setPopupPosition(150,300).add(html).setPixelSize(250,110).setStyleAttributes(popAttributes);
-  newDoc.addToFolder(DocsList.getFolder(folderName));
+
-  newDoc.removeFromFolder(DocsList.getRootFolder());
+
 }
 
-//eof 09-10_2013
+function seeTrig(e){
   if(!UserProperties.getProperty('triggers')){ UserProperties.setProperty('triggers','')};
   var Existingtriggers =  UserProperties.getProperty('triggers').split(',');
   var htmlString = '<b>Document names used as template:</b><br>'
   for(var n=1;n<Existingtriggers.length;++n){
     htmlString+='- '+Existingtriggers[n].split('|')[1]+'<br>';
   }
   var app = UiApp.getActiveApplication();
   var wait = app.getElementById('wait').setVisible(false);
   var html = app.createHTML(htmlString).setStyleAttributes(popAttributes);
   var panel = app.createScrollPanel(html);
   var pop = app.createPopupPanel(true).setPopupPosition(240,280).add(panel).setPixelSize(400,200).setStyleAttributes(popAttributes);
   pop.show();
   return app;
 }
 
 function killTrig(e){
   var Existingtriggers =  UserProperties.getProperty('triggers').split(',');
   for(var n in Existingtriggers){
     var triggers = ScriptApp.getProjectTriggers();
     for (var i = 0; i < triggers.length; i++) {
       if (triggers[i].getUniqueId() == Existingtriggers[n].split('|')[0]) {
         ScriptApp.deleteTrigger(triggers[i]);
         Logger.log('deleted '+Existingtriggers[n].split('|')[1]);
       }
     }
   }
   UserProperties.setProperty('triggers','');
   UserProperties.setProperty('mailCheck',false);
   UserProperties.setProperty('docUrls','');
   var app = UiApp.getActiveApplication();
   var wait = app.getElementById('wait').setVisible(false);
   var html = app.createHTML('All triggers have been deleted,<br>no document will be created anymore and no mails will be sent.').setStyleAttributes(popAttributes);
   var pop = app.createPopupPanel(true).setPopupPosition(150,280).add(html).setPixelSize(400,65).setStyleAttributes(popAttributes);
   pop.show();
   return app;
 }
 
 function makeTrig(e){
   var app = UiApp.getActiveApplication();
   var wait = app.getElementById('wait').setVisible(false);
   var folderName = UserProperties.getProperty('folderName');
   var docName = UserProperties.getProperty('docName');
   var docID = UserProperties.getProperty('docID');
   var chkmail='';
   if(e.parameter.mailCheck=='true'){chkmail='An email will be sent to you on every working day with the links of the 6 most recently created documents.<br>'};
   var html = app.createHTML('A new document will be created every working day around midnight based on the template ('
                             +docName+') in the chosen folder ('+folderName
                             +')<br>'+chkmail+'<br>To stop this process simply re-run this application and choose the "kill all processes" option.').setStyleAttributes(popAttributes)
   var pop = app.createPopupPanel(true).setPopupPosition(150,300).add(html).setPixelSize(400,230).setStyleAttributes(popAttributes);
   pop.show();
   var triggerID = ScriptApp.newTrigger('createDocument').timeBased().everyDays(1).atHour(0).create().getUniqueId();
   if(UserProperties.getKeys().toString().match('triggers')=='triggers'){
     var triggers =  UserProperties.getProperty('triggers').split(',');
     }else{
       var triggers = [];
       }
   triggers.push(triggerID+'|'+docName);
   UserProperties.setProperty('triggers',triggers.toString());
   return app;
 }
 
 function testCreateDocument(e){
   var IDs =  UserProperties.getProperty('IDs');
   var ID = IDs.substring(0,Number(IDs.lastIndexOf("|")));
   var doctype = IDs.substr(Number(IDs.lastIndexOf("|"))+1);
   var docname = e.parameter.Dlb
   var docN = docname.substr(0,docname.lastIndexOf("("));
   UserProperties.setProperty('docName',docN);
   UserProperties.setProperty('docID',ID);
   createDocument('test');
   var app = UiApp.getActiveApplication();
   var wait = app.getElementById('wait').setVisible(false);
   var docName = UserProperties.getProperty('docName');
   var folderName = UserProperties.getProperty('folderName');
   Logger.log(docName+' '+folderName);
   var html = app.createHTML('A test document has been created  ('+docName+') in the chosen folder ('+folderName+')').setStyleAttributes(popAttributes);
   var pop = app.createPopupPanel(true).setPopupPosition(150,280).add(html).setPixelSize(400,65).setStyleAttributes(popAttributes);
   pop.show();
   return app;
 }
 
 function createDocument(test){
   if(!test){ var today = new Date().getDay()}else{today=1};
   if(today==6 || today==0){return} ;// prevents creating doc on Saturday and Sunday
   var folderName = UserProperties.getProperty('folderName');
   var docName = UserProperties.getProperty('docName');
   var docID = UserProperties.getProperty('docID');
   var Folderhref = DocsList.getRootFolder().getUrl();
   var newDoc = DocsList.getFileById(docID).makeCopy(docName+Utilities.formatDate(new Date(),Session.getTimeZone(),'yyyy-MMM-dd'));
   if(folderName!='My Drive'){
     newDoc.addToFolder(DocsList.getFolder(folderName));
     newDoc.removeFromFolder(DocsList.getRootFolder());
     Folderhref = DocsList.getFolder(folderName).getUrl();
   }
   var newDocUrl = newDoc.getName()+'|'+newDoc.getUrl();
   if(UserProperties.getKeys().toString().indexOf('docUrls')!=-1||UserProperties.getProperty('docUrls')==''){
     var docUrls =  UserProperties.getProperty('docUrls').split(',');
     Logger.log(docUrls);
   }else{
       var docUrls = [];
     }
   var ll = docUrls.length;// check number of memorized docs
   if(ll>5){
     var newList = docUrls.splice(ll-5,5);// if more than 5 keep only last 5 docs
     var docUrls = newList;
   }
   docUrls.push(newDocUrl);
   UserProperties.setProperty('docUrls',docUrls.toString());
   var mailCheck = UserProperties.getProperty('mailCheck')=='true';
   if(!mailCheck){return};
   var msg = 'AutoDocCreator V2 report on '+Utilities.formatDate(new Date(),Session.getTimeZone(),'yyyy-MMM-dd  HH:mm')
   var txtMsg = msg+'\n\nA new document has been created for you,\nsee below the list of the most recent documents (most recent on top)\n\n'; // begin text only msg
   msg+='<br><br>A new document has been created for you,<br>see below the list of the most recent documents (most recent on top)<br>';
   msg+='created in <a href="'+Folderhref+'" target="_blank">your chosen folder ('+folderName+').</a><br><br>';
   msg+='<table style="background-color:lightblue;border-collapse:collapse;" border = 1 cellpadding = 10><tr bgcolor = "#ffaaaa">';// most recent have reddish background
   for(var n=docUrls.length-1;n>0;n--){
     var x = docUrls[n].split('|');
     var name = x[0];
     var href = x[1];
     msg+='<td>'+(docUrls.length-n)+'</td><td><a href="'+href+'" target="_blank">'+name+'</a></td></tr><tr>';// open link in other tab
     txtMsg+=(docUrls.length-n)+' - '+name+' : '+href+'\n'
   }
   msg+='</table><br><br>Use <a href="'+ScriptApp.getService().getUrl()+'" target="_blank">this link</a> to run the application that created the files<br>';
   txtMsg+='\n\nUse this link to run the application that created the files\n'+ScriptApp.getService().getUrl()+'\n';
   MailApp.sendEmail(Session.getEffectiveUser().getEmail(),'AutoCreateDoc report', txtMsg,{'htmlBody':msg});
 }
 //eof 09-14_2013