嗨，我正在使用 script1 將我的作業表的 pdf 保存到帶有年份和月份的檔案夾中因此可以在與創建日期起的年份和月份匹配的檔案夾中創建檔案。這是我的 script1 和 script2 我不知道如何將 FID 值從 script2 發送到 script1。謝謝
function script1() {
var source = SpreadsheetApp.getActiveSpreadsheet();
var ticketnum = source.getSheetByName("Ticket").getRange('J1').getValue();
var spreadsheet = spreadsheetId ? SpreadsheetApp.openById(spreadsheetId) : SpreadsheetApp.getActiveSpreadsheet();
var spreadsheetId = SpreadsheetApp.getActiveSpreadsheet().getId();
var folderID = I NEED THIS VAR TO BE THE RETURN VALUE FROM SCRIPT2 FID
var folder = DriveApp.getFolderById(folderID);
var token = ScriptApp.getOAuthToken();
var ssID = spreadsheetId;
var url = "https://docs.google.com/spreadsheets/d/" ssID "/export"
"?format=pdf&"
'&portrait=true' //orientation, false for landscape
'&scale=4'
'&top_margin=0.25' //All four margins must be set!
'&bottom_margin=0.25' //All four margins must be set!
'&left_margin=0.05' //All four margins must be set!
'&right_margin=0.05' //All four margins must be set!
'&horizontal_alignment=CENTER' //LEFT/CENTER/RIGHT
'&gid=504778977';
var response = UrlFetchApp.fetch(url, {headers: {'Authorization': 'Bearer ' token}});
var pdf = response.getBlob().setName(ticketnum '.PDF');
folder.createFile(pdf)
}
function script2() {
var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");
var folderYearDate = Utilities.formatDate(new Date(), "GMT", "yyyy");
var folderMonthDate = Utilities.formatDate(new Date(), "GMT", "MMMM");
var parent = DriveApp.getFolderByIdAndResourceKey('0B1XvUmuAadtaVmxweF95cWl4Rkk','resourcekey=0-oKRO1w6SHP1YHfuO0JxMjA').getFoldersByName("Mountain Metis")
var yearExist = parent.next();
var yearFolders = yearExist.getFoldersByName(folderYearDate);
if(yearFolders.hasNext()){
var yearFolder = yearFolders.next()
Logger.log('Yes, There is a year folder.')
//return;
} else {
var yearFolder = yearExist.createFolder(folderYearDate)
Logger.log('There was no year folder. But created')
//return;
}
var monthFolders = yearFolder.getFoldersByName(folderMonthDate);
if(monthFolders.hasNext()){
var monthFolder = monthFolders.next()
Logger.log('Yes, There is a month folder.')
} else {
var monthFolder = yearFolder.createFolder(folderMonthDate);
Logger.log('There was no month folder. But created')
}
var FID = monthFolder.getId()
Logger.log(FID)
return(FID)
}
uj5u.com熱心網友回復：
代替
var folderID = I NEED THIS VAR TO BE THE RETURN VALUE FROM SCRIPT2 FID
經過
var folderID = script2();
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/325131.html