Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

278
Views
Google Sheet + Script + ID de carpeta de retorno de un script a otro script

Hola, estoy usando script1 para guardar un pdf de mi hoja en una carpeta con el año y el mes. Lo que estoy tratando de hacer es hacer que mi script1 llame a script2 para devolver el valor de FID (FolderID) de script2 a script1 para que el archivo se pueda crear en la carpeta que coincida con el año y el mes a partir de la fecha de creación. aquí está mi script1 y script2 No estoy seguro de cómo enviar el valor FID de script2 a script1. Gracias

 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) }
about 4 years ago · Juan Pablo Isaza
1 answers
Answer question

0

Reemplazar

 var folderID = I NEED THIS VAR TO BE THE RETURN VALUE FROM SCRIPT2 FID

por

 var folderID = script2();
about 4 years ago · Juan Pablo Isaza Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!