Group items tagged

from a Spreadsheet

from a Site

As a stand-alone servlet

Deciding Whether to Run a Script from a Spreadsheet or as a Service

The built-in code autocomplete functionality in the editor requires you to type the trailing period that follows app.

Plan the script. What tasks should the script accomplish?

Write down the specific information you want to display to or collect from your users.

Draw the user interface

Determine what the script and interface should do in response to any user input.

Determine the conditions for exiting the script.

you need a UiApp application object to contain the user interface elements. After you create the UiApp application object, you can add buttons, dialog boxes, panels, and other elements to the UiApp application object.

The general syntax for these operations is as follows:

To create a UiApp application object, use the syntax var your_application_object_name = UiApp.createApplication();

To create a user interface element and associate it with your UiApp application object, use the syntax var your_ui_element_name= your_application_object_name.createElement_Name();.

To add one user interface element to another

use the syntax your_ui_element_name1.add(your_ui_element_name2);

a button with the text Press Me on it:

creates a vertical panel.

other kinds of panels

pop-up panels, stack panels, focus panels, form panels, and so on.

code for displaying your button on the panel:

add the panel to the application:

nstruct Google Apps Script to display the interface elements:

You can create the user interface elements in any order.

the display order

Creating the elements and adding them to your application are separate steps requiring separate instructions.

a short script that does nothing but display a panel with a button on it.

You can chain together setter methods

sets its title

set the size of the object:

how to use Grid objects and the setWidget method to create a more complex layout and also how to create text boxes and label them.

To make a user interface useful, you need the ability to update a Spreadsheet with information a user enters from the interface.

a short script that responds to an action in the interface by updating the Spreadsheet.

looping structure in the script to keep the panel displayed and active

Server-side means that the actions are performed by a server

same script, with functions added that enable the form to be used multiple times before a user chooses to exit.

script collects some information from text fields on a panel and writes that information into the Spreadsheet.

You can make a script's user interface available to users from inside a Spreadsheet or Site or by running it separately as a service.

how to make the user interface as a service.

A script that provides a stand-alone user interface must invoke the doGet(e) function or the doPost(e) function for an HTML form submit.

A script that provides the user interface from the Spreadsheet invokes doc.show(app).

The doGet(e) function takes the argument e, passing in the arguments for the user interface, including the user name of the person invoking the script.

After you write the script, you publish it as a service. During the publishing process, you define who has access to the script.

In a Google Apps domain, you can publish the script so that only you have access or so that everyone in the domain has access.

In a Google consumer account, you can publish the script so that only you have access or so that everyone in the world has access.

Updating a Spreadsheet from the User Interface, the user interface is displayed from the Spreadsheet where the script is stored. The following code defines how the user interface is displayed:

Here's the skeleton code for displaying a user interface as a stand-alone service:

some aspects of the two ways to display a user interface.