Class 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 Google Workspace dialogs instead.

Properties

Property	Type	Description
`Buttons`	`ButtonSet`

Methods

Method	Return type	Brief description
`inputBox(prompt)`	`String`	Pops up a dialog box with a text input box in the user's browser.
`inputBox(prompt, buttons)`	`String`	Pops up a dialog box with a text input box in the user's browser.
`inputBox(title, prompt, buttons)`	`String`	Pops up a dialog box with a text input box in the user's browser.
`msgBox(prompt)`	`String`	Pops up a dialog box with the given message and an OK button in the user's browser.
`msgBox(prompt, buttons)`	`String`	Pops up a dialog box with the given message and specified buttons in the user's browser.
`msgBox(title, prompt, buttons)`	`String`	Pops 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 resumes automatically after the user clears the dialog, but JDBC connections don't persist across the suspension.

// The code below sets 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

Name	Type	Description
`prompt`	`String`	The text to be displayed in the dialog box.

Return

String — The 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 resumes automatically after the user clears the dialog, but JDBC connections don't persist across the suspension.

// The code below sets 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

Name	Type	Description
`prompt`	`String`	The text to be displayed in the dialog box.
`buttons`	`ButtonSet`	The type of button set to use.

Return

String — The 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 resumes automatically after the user clears the dialog, but JDBC connections don't persist across the suspension.

// The code below sets 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

Name	Type	Description
`title`	`String`	The title for the dialog box.
`prompt`	`String`	The text to be displayed in the dialog box.
`buttons`	`ButtonSet`	The type of button set to use.

Return

String — The 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 resumes automatically after the user clears the dialog, but JDBC connections don't persist across the suspension.

// The code below displays "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

Name	Type	Description
`prompt`	`String`	The text to be displayed in the dialog box.

Return

String — The 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 resumes automatically after the user clears the dialog, but JDBC connections don't persist across the suspension.

// The code below displays "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

Name	Type	Description
`prompt`	`String`	The text to be displayed in the dialog box.
`buttons`	`ButtonSet`	The type of button set to use.

Return

String — The 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 resumes automatically after the user clears the dialog, but JDBC connections don't persist across the suspension.

// The code below displays "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

Name	Type	Description
`title`	`String`	The title of the dialog box.
`prompt`	`String`	The text to be displayed in the dialog box.
`buttons`	`ButtonSet`	The type of button set to use.

Return

String — The 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

Class Browser

See also

Properties

Methods

Detailed documentation

inputBox(prompt)

Parameters

Return

Authorization

inputBox(prompt, buttons)

Parameters

Return

Authorization

inputBox(title, prompt, buttons)

Parameters

Return

Authorization

msgBox(prompt)

Parameters

Return

Authorization

msgBox(prompt, buttons)

Parameters

Return

Authorization

msgBox(title, prompt, buttons)

Parameters

Return

Authorization

`inputBox(prompt)`

`inputBox(prompt, buttons)`

`inputBox(title, prompt, buttons)`

`msgBox(prompt)`

`msgBox(prompt, buttons)`

`msgBox(title, prompt, buttons)`