Hello, This line of code uses the id entered manually in the script let copyFile = DriveApp.getFileById('1GhpGpHM......').makeCopy(), copyID = copyFile.getId(), copyDoc = DocumentApp.openById(copyID), How could I use the ID that can be found manually written in the google spreadsheet, so that if I change it from the spreadsheet, it will also change automatically in the script. I have a list of IDs associated with some templates. I used : var ID_template = ss.getRangeByName('ID_template').getValue; let copyFile = DriveApp.getFileById(ID_template).makeCopy(), copyID = copyFile.getId(), copyDoc = DocumentApp.openById(copyID), but without any result. Can something be done about this?
Hi, iam working on one task where i need to show all the folders in Google drive and its content on a website or on URl. (Similarly how we use file explorer on local computer drive). Secondly,i want to have username and password to webpage so whenever the page is accessed it should prompt for username and password. Upon correct user name and password it should show folderd. Please share your idea☺
If I copy url from browser address and paste it directly in the script, SpreadsheetApp.openByUrl works. But if I get the url from DriveApp, SpreadsheetApp.openByUrl fails.
You're a LEGEND. I have been searching for a tutorial on exactly this for so long and this is the first one that solved my problem!
Good one thanks so much !!
This function works well from the console but from a document,
the call to Driveapp does not work, why? What's left to define? SORRY FOR MY ENGLISH
Hello,
This line of code uses the id entered manually in the script
let copyFile = DriveApp.getFileById('1GhpGpHM......').makeCopy(),
copyID = copyFile.getId(),
copyDoc = DocumentApp.openById(copyID),
How could I use the ID that can be found manually written in the google spreadsheet, so that if I change it from the spreadsheet, it will also change automatically in the script. I have a list of IDs associated with some templates.
I used :
var ID_template = ss.getRangeByName('ID_template').getValue;
let copyFile = DriveApp.getFileById(ID_template).makeCopy(),
copyID = copyFile.getId(),
copyDoc = DocumentApp.openById(copyID),
but without any result.
Can something be done about this?
Dear Can you explain further if we want to go to a specific folder first then we want to search the files
Is there any way to add the file name into a cell an example would be I want the file name in cell a1 is their script I can write to get that?
Hi, iam working on one task where i need to show all the folders in Google drive and its content on a website or on URl. (Similarly how we use file explorer on local computer drive). Secondly,i want to have username and password to webpage so whenever the page is accessed it should prompt for username and password. Upon correct user name and password it should show folderd. Please share your idea☺
Superb, need some live projects at appscript bro🎉🎉🎉🎉🎉🎉 ready to make subscription also
Plz post UPI id at description to make an payment
SpreadsheetApp.openById and SpreadsheetApp.openByUrl no longer works. Error message : Spreadsheets failed while accessing document
If I copy url from browser address and paste it directly in the script, SpreadsheetApp.openByUrl works. But if I get the url from DriveApp, SpreadsheetApp.openByUrl fails.
How to get folders ID instead of files ID
+1