I’m making apps script to find files that don’t contain the names “Done” and “InProgress”. The script that I have created is like this:
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); } }
After I run the script, the results do not match.