Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. function testSearch(){
  2. var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  3.  
  4. var parentFolder = DriveApp.getFolderById('1gr0RIGIt0AEzEqIxJigGxYlxQGy8yLqp')
  5. var allFile = parentFolder.getFiles()
  6.  
  7. var filter = parentFolder.searchFiles('fullText not contains "Done"' && 'fullText not contains "InProgress"');
  8.  
  9. var cnt = 0;
  10.  
  11. while (allFile.hasNext()) {
  12. var filter = allFile.next();
  13. cnt++;
  14. var data = [
  15. filter.getName(),
  16. filter.getUrl(),
  17. ];
  18. sheet.appendRow(data);
  19. }
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement