This is my script:
function main(filename) {
var files = DriveApp.getFilesByName(filename);
if (files.hasNext()) {
var file = files.next();
var fileURL = file.getUrl();
// Get the folder containing the file
var folder = file.getParents().next();
// Set sharing permission to anyone can view
folder.setSharing(DriveApp.Access.ANYONE, DriveApp.Permission.VIEW);
return fileURL;
} else {
throw new Error("File not found: " + filename);
}
}
In my case, I set the sharing parameters so anyone can see the file, but you can modify the permissions depending on your needs.
It is important to properly set the filename function parameter, which will vary depending on the folder path where the file is stored. If that's not set correctly, the script will run, but you won't get the return of the URL.
Consider the following example:
This is my folder path where the file is stored: Purchases_Files/6e3ff2f6.FILE.172426.pdf
This is my function parameter: INDEX(SPLIT([FILE], "/"), 2)
The purpose of the function is to extract the file name "6e3ff2f6.FILE.172426.pdf" from the full file path "Purchases_Files/6e3ff2f6.FILE.172426.pdf"
If your file is stored in a path with more subfolders, you should modify the number 2, as that part of the function takes the nth element of the array produced by the SPLIT function.
Hope this helps.
LinkedIn
Twitter
