Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function testSearch(){
- var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
- var parentFolder = DriveApp.getFolderById('1gr0RIGIt0AEzEqIxJigGxYlxQGy8yLqp')
- var allFile = parentFolder.getFiles()
- var filter = parentFolder.searchFiles('fullText not contains "Done"' && 'fullText not contains "InProgress"');
- var cnt = 0;
- while (allFile.hasNext()) {
- var filter = allFile.next();
- cnt++;
- var data = [
- filter.getName(),
- filter.getUrl(),
- ];
- sheet.appendRow(data);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement