Does anyone know hot to get the name of a file on drive using an URL?
At the moment I have the below code but it just hangs for some reason :(.
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var jobID = 262;
var jobFormUrl = 'URL';
var jobFormId = getIdFromUrl(jobFormUrl);
var filename = DriveApp.getFileById(jobFormId).getName();
ss.getSheetByName('Job ID '+jobID).getRange(2,2).setValue('=hyperlink("'+jobFormUrl+'","'+filename+'")');
}
function getIdFromUrl(url) {
return url.match(/[-\w]{25,}/);
}