Class Browser

Browser

This class provides access to dialog boxes specific to Google Sheets.

The methods in this class are only available for use in the context of a Google Spreadsheet. Please use G Suite dialogs instead.

See also

Properties

PropertyTypeDescription
ButtonsButtonSet

Methods

MethodReturn typeBrief description
inputBox(prompt)StringPops up a dialog box with a text input box in the user's browser.
inputBox(prompt, buttons)StringPops up a dialog box with a text input box in the user's browser.
inputBox(title, prompt, buttons)StringPops up a dialog box with a text input box in the user's browser.
msgBox(prompt)StringPops up a dialog box with the given message and an OK button in the user's browser.
msgBox(prompt, buttons)StringPops up a dialog box with the given message and specified buttons in the user's browser.
msgBox(title, prompt, buttons)StringPops up a dialog box with the given title, message and specified buttons in the user's browser.

Detailed documentation

inputBox(prompt)

Pops up a dialog box with a text input box in the user's browser.

The inputBox method raises a client-side input box that displays the given prompt to the user. Note that this function causes the server-side script to be suspended. It will resume automatically after the user clears the dialog, but JDBC connections will not persist across the suspension.

// The code below will set the value of name to the name input by the user, or 'cancel'
var name = Browser.inputBox('Enter your name');
This method is not recommended. Instead, use a UI prompt.

Parameters

NameTypeDescription
promptStringthe text to be displayed in the dialog box

Return

String — text entered by the user (or 'cancel' for a canceled or dismissed dialog)

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

inputBox(prompt, buttons)

Pops up a dialog box with a text input box in the user's browser.

The inputBox method raises a client-side input box that displays the given prompt to the user, and offers a choice of buttons to be displayed. Note that this function causes the server-side script to be suspended. It will resume automatically after the user clears the dialog, but JDBC connections will not persist across the suspension.

// The code below will set the value of name to the name input by the user, or 'cancel'
var name = Browser.inputBox('Enter your name', Browser.Buttons.OK_CANCEL);
This method is not recommended. Instead, use a UI prompt.

Parameters

NameTypeDescription
promptStringthe text to be displayed in the dialog box
buttonsButtonSetan enum from Browser.Buttons

Return

String — text entered by the user (or 'cancel' for a canceled or dismissed dialog)

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

inputBox(title, prompt, buttons)

Pops up a dialog box with a text input box in the user's browser.

The inputBox method raises a client side input box with the given title, that displays the given prompt to the user, and offers a choice of buttons to be displayed. Note that this function causes the server-side script to be suspended. It will resume automatically after the user clears the dialog, but JDBC connections will not persist across the suspension.

// The code below will set the value of name to the name input by the user, or 'cancel'
var name = Browser.inputBox('ID Check', 'Enter your name', Browser.Buttons.OK_CANCEL);
This method is not recommended. Instead, use a UI prompt.

Parameters

NameTypeDescription
titleStringthe title for the dialog box
promptStringthe text to be displayed in the dialog box
buttonsButtonSetan enum from Browser.Buttons

Return

String — text entered by the user (or 'cancel' for a canceled or dismissed dialog)

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

msgBox(prompt)

Pops up a dialog box with the given message and an OK button in the user's browser.

The msgBox method raises a client-side message box that displays the given message to the user. Note that this method causes the server-side script to be suspended. It will resume automatically after the user clears the dialog, but JDBC connections will not persist across the suspension.

// The code below will display "hello world" in a dialog box with an OK button
Browser.msgBox('hello world');
This method is not recommended. Instead, use a UI alert dialog.

Parameters

NameTypeDescription
promptStringthe text to be displayed in the dialog box

Return

String — lower case text of the button that is clicked by the user (or 'cancel' for a dismissed dialog)

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

msgBox(prompt, buttons)

Pops up a dialog box with the given message and specified buttons in the user's browser.

The msgBox method raises a client-side message box that displays the given message to the user, and offers a choice of buttons to be displayed. Note that this method causes the server-side script to be suspended. It will resume automatically after the user clears the dialog, but JDBC connections will not persist across the suspension.

// The code below will display "hello world" in a dialog box with OK and Cancel buttons
Browser.msgBox('hello world', Browser.Buttons.OK_CANCEL);
This method is not recommended. Instead, use a UI alert dialog.

Parameters

NameTypeDescription
promptStringthe text to be displayed in the dialog box
buttonsButtonSetan enum from Browser.Buttons

Return

String — lower case text of the button that is clicked by the user (or 'cancel' for a dismissed dialog)

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

msgBox(title, prompt, buttons)

Pops up a dialog box with the given title, message and specified buttons in the user's browser.

The msgBox method raises a client-side message box with the given title, that displays the given message to the user, and offers a choice of buttons to be displayed. Note that this method causes the server-side script to be suspended. It will resume automatically after the user clears the dialog, but JDBC connections will not persist across the suspension.

// The code below will display "hello world" in a dialog box with a custom title and Yes and
// No buttons
Browser.msgBox('Greetings', 'hello world', Browser.Buttons.YES_NO);
This method is not recommended. Instead, use a UI alert dialog.

Parameters

NameTypeDescription
titleStringthe title of the dialog box
promptStringthe text to be displayed in the dialog box
buttonsButtonSetan enum from Browser.Buttons

Return

String — lower case text of the button that is clicked by the user (or 'cancel' for a dismissed dialog)

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

Send feedback about...

Apps Script
Apps Script
Need help? Visit our support page.