Class Menu

Menu

A custom menu in an instance of the user interface for a Google App. A script can only interact with the UI for the current instance of an open document or form, and only if the script is container-bound to the document or form. For more information, see the guide to menus.

// Add a custom menu to the active spreadsheet, including a separator and a sub-menu.
function onOpen(e) {
  SpreadsheetApp.getUi()
      .createMenu('My Menu')
      .addItem('My Menu Item', 'myFunction')
      .addSeparator()
      .addSubMenu(SpreadsheetApp.getUi().createMenu('My Submenu')
          .addItem('One Submenu Item', 'mySecondFunction')
          .addItem('Another Submenu Item', 'myThirdFunction'))
      .addToUi();
}

Methods

MethodReturn typeBrief description
addItem(caption, functionName)MenuAdds an item to the menu.
addSeparator()MenuAdds a visual separator to the menu.
addSubMenu(menu)MenuAdds a sub-menu to the menu.
addToUi()voidInserts the menu into the instance of the editor's user interface.

Detailed documentation

addItem(caption, functionName)

Adds an item to the menu. The label for a menu item should be in sentence case (only the first word capitalized).

Parameters

NameTypeDescription
captionStringThe label for the menu item, with only the first word capitalized.
functionNameStringThe name of the function to invoke when the user selects the item. You can use functions from included libraries, such as Library.libFunction1.

Return

Menu — This Menu, for chaining.


addSeparator()

Adds a visual separator to the menu.

Return

Menu — This Menu, for chaining.


addSubMenu(menu)

Adds a sub-menu to the menu.

Parameters

NameTypeDescription
menuMenuThe sub-menu, constructed like a top-level menu.

Return

Menu — This Menu, for chaining.


addToUi()

Inserts the menu into the instance of the editor's user interface.

다음에 대한 의견 보내기...

도움이 필요하시나요? 지원 페이지를 방문하세요.