Class Ui

// Display "Hello, world" in a dialog box with an "OK" button. The user can also // close the dialog by clicking the close button in its title bar. SpreadsheetApp.getUi().alert('Hello, world');

// Display a dialog box with a message and "Yes" and "No" buttons. The user can // also close the dialog by clicking the close button in its title bar. const ui = SpreadsheetApp.getUi(); const response = ui.alert(     'Are you sure you want to continue?',     ui.ButtonSet.YES_NO, );  // Process the user's response. if (response === ui.Button.YES) {   Logger.log('The user clicked "Yes."'); } else {   Logger.log(       'The user clicked "No" or the close button in the dialog\'s title bar.',   ); }

// Display a dialog box with a title, message, and "Yes" and "No" buttons. The // user can also close the dialog by clicking the close button in its title bar. const ui = SpreadsheetApp.getUi(); const response = ui.alert(     'Confirm',     'Are you sure you want to continue?',     ui.ButtonSet.YES_NO, );  // Process the user's response. if (response === ui.Button.YES) {   Logger.log('The user clicked "Yes."'); } else {   Logger.log(       'The user clicked "No" or the close button in the dialog\'s title bar.',   ); }

// Add an item to the add-on menu, under a sub-menu whose name is set // automatically. function onOpen(e) {   SpreadsheetApp.getUi()       .createAddonMenu()       .addItem('Show', 'showSidebar')       .addToUi(); }

// Add a custom menu to the active document, 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 sub-menu')               .addItem('One sub-menu item', 'mySecondFunction')               .addItem('Another sub-menu item', 'myThirdFunction'),           )       .addToUi(); }

// Display a dialog box with a message, input field, and an "OK" button. The // user can also close the dialog by clicking the close button in its title bar. const ui = SpreadsheetApp.getUi(); const response = ui.prompt('Enter your name:');  // Process the user's response. if (response.getSelectedButton() === ui.Button.OK) {   Logger.log('The user\'s name is %s.', response.getResponseText()); } else {   Logger.log('The user clicked the close button in the dialog\'s title bar.'); }

// Display a dialog box with a message, input field, and "Yes" and "No" buttons. // The user can also close the dialog by clicking the close button in its title // bar. const ui = SpreadsheetApp.getUi(); const response = ui.prompt('May I know your name?', ui.ButtonSet.YES_NO);  // Process the user's response. if (response.getSelectedButton() === ui.Button.YES) {   Logger.log('The user\'s name is %s.', response.getResponseText()); } else if (response.getSelectedButton() === ui.Button.NO) {   Logger.log('The user didn\'t want to provide a name.'); } else {   Logger.log('The user clicked the close button in the dialog\'s title bar.'); }

// Display a dialog box with a title, message, input field, and "Yes" and "No" // buttons. The user can also close the dialog by clicking the close button in // its title bar. const ui = SpreadsheetApp.getUi(); const response = ui.prompt(     'Getting to know you',     'May I know your name?',     ui.ButtonSet.YES_NO, );  // Process the user's response. if (response.getSelectedButton() === ui.Button.YES) {   Logger.log('The user\'s name is %s.', response.getResponseText()); } else if (response.getSelectedButton() === ui.Button.NO) {   Logger.log('The user didn\'t want to provide a name.'); } else {   Logger.log('The user clicked the close button in the dialog\'s title bar.'); }

// Display a modal dialog box with custom HtmlService content. const htmlOutput = HtmlService                        .createHtmlOutput(                            '<p>A change of speed, a change of style...</p>',                            )                        .setWidth(250)                        .setHeight(300); SpreadsheetApp.getUi().showModalDialog(htmlOutput, 'My add-on');

// Display a modeless dialog box with custom HtmlService content. const htmlOutput = HtmlService                        .createHtmlOutput(                            '<p>A change of speed, a change of style...</p>',                            )                        .setWidth(250)                        .setHeight(300); SpreadsheetApp.getUi().showModelessDialog(htmlOutput, 'My add-on');

// Display a sidebar with custom HtmlService content. const htmlOutput = HtmlService                        .createHtmlOutput(                            '<p>A change of speed, a change of style...</p>',                            )                        .setTitle('My add-on'); SpreadsheetApp.getUi().showSidebar(htmlOutput);