Custom Menus in Google Workspace | Apps Script | Google Developers
Sat Jun 25 2022 16:32:05 GMT+0000 (Coordinated Universal Time)
Saved by
@Waydes
#javascript
function onOpen() {
var ui = SpreadsheetApp.getUi();
// Or DocumentApp or FormApp.
ui.createMenu('Custom Menu')
.addItem('First item', 'menuItem1')
.addSeparator()
.addSubMenu(ui.createMenu('Sub-menu')
.addItem('Second item', 'menuItem2'))
.addToUi();
}
function menuItem1() {
SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
.alert('You clicked the first menu item!');
}
function menuItem2() {
SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
.alert('You clicked the second menu item!');
}
content_copyCOPY
https://developers.google.com/apps-script/guides/menus
Comments