google sheet script create a cistom menu
// Google Apps Scipt custom menu example code 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!'); }
