Google Apps Script - introduction - 0 views
code.google.com/...guide_user_interfaces.html
google script apps Programming javascript tool tools infrastructure
shared by Tiberius Brastaviceanu on 03 May 11
- No Cached
-
Google Apps Script provides you with the ability to build a user interface for displaying or capturing information.
-
Viewing the Available User Interface Elements
-
Your scripts can display the user interface in two ways:
- ...48 more annotations...
-
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.
