Get best of the week

Workflow on Google Drive?

It would seem that here it is a common information space in which you can distribute access rights, organize files and add additional fields to them. What is missing for electronic document management? Already at several large construction sites, we tried Google Drive in the workflow, found popular rakes and successful solutions. On May holidays, I (finally!) Packed this experience into a 7-minute video, selecting the most useful tricks.

image

Although the examples are from construction topics, since this is my area of ​​work (managerial accounting, financial planning, visualization, etc.), they are quite applicable in any other:


The most interesting, in my opinion, is the structure on sheet 2 combining the advantages of a human-readable form and a relational database. On the one hand, people simply enter data in a convenient structure, see the hierarchy and all kinds of adders, on the other hand, they can be addressed even with a SQL query (for this, Google tables have the QUERY formula), even form a summary table in a couple of clicks.

Well, if someone comes in handy a script to upload files “directly to table cells”, I’m sharing. With detailed comments, it is easy to read, like a dumpling recipe:

//     
function createFolder(){
  //  ,    
  var currentCell = SpreadsheetApp.getCurrentCell(); 
  // ,    (    )
  if (currentCell.isBlank()) {
    //   
    var ss = SpreadsheetApp.getActiveSpreadsheet(); //  
    //         ,     ,   
    //       ,  id     1   "settings",       
    //     settings
    var settingsSheet = ss.getSheetByName("settings");
    //    ,          (..   )
    if (!settingsSheet) {
      //   
      var contentFolder = DriveApp.getFileById(ss.getId()).getParents().next().createFolder(" "+ss.getName());
      //   settings
      settingsSheet = ss.insertSheet('settings');
      //  ,    
      settingsSheet.hideSheet();
      //    1 id  
      settingsSheet.getRange(1, 1).setValue(contentFolder.getId());
    };
    //      (      ,       )
    var newFolder = DriveApp.getFolderById(settingsSheet.getRange(1, 1).getValue()).createFolder((new Date()).toISOString());
    //      ""    
    currentCell.setFormula('=HYPERLINK("https://drive.google.com/drive/folders/' + newFolder.getId() + '";"")');
  }else{
    //       ,  
    Browser.msgBox("      ")
  }
}

It is interesting to learn constructive criticism from those who are in the subject. Well, any useful opinions, additions, tips.

More articles:


All Articles