Getting started with google-apps-script Spreadsheet Service DriveApp Service - Files by type and search string Spreadsheet Add Menu Apps Script Web Apps Google sheets MailApp DriveApp Create a custom function for Google Sheets SpreadsheetApp Active Sheet GmailApp DriveApp - getFileById(id)DriveApp Service Google Web App Script To Auto Download From Google Drive Client calls to Google apps-script Firebase and AppScript : Introduction

Spreadsheet Add Menu

Remarks:

Usually, you will want to call addMenu from the onOpen function so that the menu is automatically created when the Spreadsheet is loaded.

 // The onOpen function is executed automatically every time a Spreadsheet is loaded
 function onOpen() {
   var activeSheet = SpreadsheetApp.getActiveSpreadsheet();
   var menuItems = [];
   // When the user clicks on "addMenuExample" then "Menu 1", the function Myfunction1 is executed.
   menuItems.push({name: "Menu 1", functionName: "Myfunction1"});
   menuItems.push(null); // adding line separator
   menuItems.push({name: "Menu 2", functionName: "Myfunction2"});

   activeSheet.addMenu("addMenuExample", menuEntries);
 }

Create a new menu

Creates a new menu in the Spreadsheet UI. Each menu entry runs a user-defined function.

   var activeSheet = SpreadsheetApp.getActiveSpreadsheet();
   var menuItems = [];
   // When the user clicks on "addMenuExample" then "Menu 1", the function Myfunction1 is executed.
   menuItems.push({name: "Menu 1", functionName: "Myfunction1"});
   menuItems.push(null); // adding line separator
   menuItems.push({name: "Menu 2", functionName: "Myfunction2"});

   activeSheet.addMenu("addMenuExample", menuEntries);

Create Custom Menu

Method: To Create Custom Menu This is First Function to be called when App Loads

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('My HR')
      .addItem('Send Form to All', 'sendIDPForm_All')
      .addItem('Trigger IDP System', 'applyCategory')
      .addToUi();
}

Syntax:

addMenu(name, subMenus)

Parameters:

Name	Description
name	the name of the menu to be created
subMenus	an array of JavaScript maps

Contributors

Topic Id: 4253

Example Ids: 14879,32561

This site is not affiliated with any of the contributors.