Skip to content

Instantly share code, notes, and snippets.

@eojji
Created July 9, 2018 06:58
Show Gist options
  • Save eojji/beaa379dda9f506c4b2cf8ced9fa4484 to your computer and use it in GitHub Desktop.
Save eojji/beaa379dda9f506c4b2cf8ced9fa4484 to your computer and use it in GitHub Desktop.
drive ListFiles AppMaker. drive 05 - Google App Maker. https://cafe.naver.com/eojji/331
/**
* https://developers.google.com/appmaker/tutorials/call-scripts/
* @param {widget} widget - Button widget.
* @param {event}
*/
function onListFilesClick(widget, event) {
var widgets = widget.parent.descendants;
var from = widgets.TextBoxFromFolder.value;
var to = widgets.TextBoxToFolder.value;
google.script.run.withSuccessHandler(
function(resp) {
widgets.LinkSpreadSheet.text = resp.name;
widgets.LinkSpreadSheet.href = resp.url;
}
)
.myListFiles(from, to);
}
function myListFiles(folderId, parentId) {
var startTime = Date.now();
var ssNew = SpreadsheetApp.create('_gfolder, '+startTime);
var sheetFolder = ssNew.getSheets()[0];
sheetFolder.setName('folder');
sheetFolder.appendRow(["row to read", 0]);
sheetFolder.appendRow(["title", "id", "id2", "files", "fileSize", "start", "end", "file row", "parent"]);
// files
var sheetFiles = ssNew.insertSheet('files');
sheetFiles.appendRow(["row to read", 0, "page token"]);
sheetFiles.appendRow(['title', 'id', 'mime', 'size', 'copy', 'name', 'message', 'check', 'parent']);
var pageToken;
var objFiles = listFilesByPageToken_(folderId, pageToken, startTime);
if (objFiles) {
sheetAppendFiles_(parentId, objFiles.files, sheetFolder, sheetFiles);
}
return { name: ssNew.getName(), url: ssNew.getUrl()};
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment