How to trigger UI class for Google Sheets?

Question

My goal

Here is the documentation I'm trying to follow.

// 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.
var ui = SpreadsheetApp.getUi();
var 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.');
}

What I expect to happen and what happens instead

I expect the UI to 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.

But instead, nothing happens.

Steps to reproduce.

Open a Google Sheet.
Open Script Editor: Tools > Script editor
Paste above code into script editor.
Close script editor.
Navigate to Google Sheet.

But as I mentioned, nothing actually happened.

How do I trigger the UI instance to initiate? What am I doing wrong?

Cooper · Accepted Answer · 2019-11-08 21:50:27Z

1

Run this function:

function runIt() {
  var ui = SpreadsheetApp.getUi();
  var response = ui.prompt('Getting to know you', 'May I know your name?', ui.ButtonSet.YES_NO);
  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.');
  }
}

After getting the function to run go look at the spreadsheet.

edited Nov 8, 2019 at 21:50

answered Nov 8, 2019 at 20:41

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to trigger UI class for Google Sheets?

My goal

What I expect to happen and what happens instead

Steps to reproduce.

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

My goal

What I expect to happen and what happens instead

Steps to reproduce.

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related