Created
July 9, 2018 06:58
-
-
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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* 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); | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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