Getting a yes/no response and text input

var userInterface = SpreadsheetApp.getUi();
  var getResponse = userInterface.prompt('This is the title', 'This is the question', userInterface.ButtonSet.YES_NO);
  if(getResponse.getSelectedButton() == userInterface.Button.YES)
  {
    Browser.msgBox("You said yes");
    Browser.msgBox('You just keyed in:' + getResponse.getResponseText());
  }else
  {
    Browser.msgBox("You said no");
  }

Comments

Post a Comment

Popular posts from this blog

Popup message box

Code: Browser.msgBox("Hello!", Browser.Buttons.OK) Another popup message box is the toast, which shows up at the lower-right hand corner of the spreadsheet (this only works with sheets): SpreadsheetApp.getActiveSpreadsheet().toast("Hello", "This is the title"); If timeout seconds is set to -1, it means that the toast will be there forever. Create a modeless dialog that does not prevent you from doing other things: function showDialog() {   var html = HtmlService.createHtmlOutputFromFile('hi');   SpreadsheetApp.getUi().showModelessDialog(html, 'This is the title') }
Read more

Create a menu

Code: function makeMenu() {   DocumentApp.getUi().createMenu("Top Menu Text").addItem("Sub menu function is toastMe", "toastMe").addToUi(); } To make it load on startup, change function name to onOpen()
Read more