Google Apps Script – search File ID with custom open dialog – part 052. – free-tutorials.org with free tutorials and source code

This Google Apps Script new script shows a dialog with :

a label with the text: “Enter the file name to search for:” ;
an edit box for the name of the file;
the Ok button to run the script;

The script will search the file ID and will show you a dialog message like this:
File ID: your_File_ID_of the file

This is the source code I used:

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu("File ID Search")
      .addItem("Find File ID", "findFileID")
      .addToUi();
}

function findFileID() {
  var ui = SpreadsheetApp.getUi();
  
  var fileName = ui.prompt("Enter the file name to search for:").getResponseText();
  
  var fileId = getFileIdByName(fileName);
  
  if (fileId) {
    ui.alert("File ID: " + fileId);
  } else {
    ui.alert("File not found.");
  }
}

function getFileIdByName(fileName) {
  var files = DriveApp.getFilesByName(fileName);
  
  if (files.hasNext()) {
    var file = files.next();
    return file.getId();
  } else {
    return null;
  }
}

function onOpen() {

var ui = SpreadsheetApp.getUi();

ui.createMenu("File ID Search")

.addItem("Find File ID", "findFileID")

.addToUi();

}

function findFileID() {

var ui = SpreadsheetApp.getUi();

var fileName = ui.prompt("Enter the file name to search for:").getResponseText();

var fileId = getFileIdByName(fileName);

if (fileId) {

ui.alert("File ID: " + fileId);

} else {

ui.alert("File not found.");

}

function getFileIdByName(fileName) {

var files = DriveApp.getFilesByName(fileName);

if (files.hasNext()) {

var file = files.next();

return file.getId();

} else {

return null;

}

Leave a Reply Cancel reply