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.

Geographical access control may be enforced by personnel (e.g., border guard, bouncer, ticket checker)

n alternative of access control in the strict sense (physically controlling access itself) is a system of checking authorized presence, see e.g. Ticket controller (transportation). A variant is exit control, e.g. of a shop (checkout) or a country

access control refers to the practice of restricting entrance to a property, a building, or a room to authorized persons

can be achieved by a human (a guard, bouncer, or receptionist), through mechanical means such as locks and keys, or through technological means such as access control systems like the mantrap.

Physical access control is a matter of who, where, and when

Historically, this was partially accomplished through keys and locks. When a door is locked, only someone with a key can enter through the door, depending on how the lock is configured. Mechanical locks and keys do not allow restriction of the key holder to specific times or dates. Mechanical locks and keys do not provide records of the key used on any specific door, and the keys can be easily copied or transferred to an unauthorized person. When a mechanical key is lost or the key holder is no longer authorized to use the protected area, the locks must be re-keyed.[citation needed] Electronic access control uses computers to solve the limitations of mechanical locks and keys. A wide range of credentials can be used to replace mechanical keys. The electronic access control system grants access based on the credential presented. When access is granted, the door is unlocked for a predetermined time and the transaction is recorded. When access is refused, the door remains locked and the attempted access is recorded. The system will also monitor the door and alarm if the door is forced open or held open too long after being unlocked

Credential

Access control system operation

The above description illustrates a single factor transaction. Credentials can be passed around, thus subverting the access control list. For example, Alice has access rights to the server room, but Bob does not. Alice either gives Bob her credential, or Bob takes it; he now has access to the server room. To prevent this, two-factor authentication can be used. In a two factor transaction, the presented credential and a second factor are needed for access to be granted; another factor can be a PIN, a second credential, operator intervention, or a biometric input

There are three types (factors) of authenticating information:[2] something the user knows, e.g. a password, pass-phrase or PIN something the user has, such as smart card or a key fob something the user is, such as fingerprint, verified by biometric measurement

Passwords are a common means of verifying a user's identity before access is given to information systems. In addition, a fourth factor of authentication is now recognized: someone you know, whereby another person who knows you can provide a human element of authentication in situations where systems have been set up to allow for such scenarios

When a credential is presented to a reader, the reader sends the credential’s information, usually a number, to a control panel, a highly reliable processor. The control panel compares the credential's number to an access control list, grants or denies the presented request, and sends a transaction log to a database. When access is denied based on the access control list, the door remains locked.

A credential is a physical/tangible object, a piece of knowledge, or a facet of a person's physical being, that enables an individual access to a given physical facility or computer-based information system. Typically, credentials can be something a person knows (such as a number or PIN), something they have (such as an access badge), something they are (such as a biometric feature) or some combination of these items. This is known as multi-factor authentication. The typical credential is an access card or key-fob, and newer software can also turn users' smartphones into access devices.

An access control point, which can be a door, turnstile, parking gate, elevator, or other physical barrier, where granting access can be electronically controlled. Typically, the access point is a door. An electronic access control door can contain several elements. At its most basic, there is a stand-alone electric lock. The lock is unlocked by an operator with a switch. To automate this, operator intervention is replaced by a reader. The reader could be a keypad where a code is entered, it could be a card reader, or it could be a biometric reader. Readers do not usually make an access decision, but send a card number to an access control panel that verifies the number against an access list

monitor the door position

Generally only entry is controlled, and exit is uncontrolled. In cases where exit is also controlled, a second reader is used on the opposite side of the door. In cases where exit is not controlled, free exit, a device called a request-to-exit (REX) is used. Request-to-exit devices can be a push-button or a motion detector. When the button is pushed, or the motion detector detects motion at the door, the door alarm is temporarily ignored while the door is opened. Exiting a door without having to electrically unlock the door is called mechanical free egress. This is an important safety feature. In cases where the lock must be electrically unlocked on exit, the request-to-exit device also unlocks the doo

Access control topology

Access control decisions are made by comparing the credential to an access control list. This look-up can be done by a host or server, by an access control panel, or by a reader. The development of access control systems has seen a steady push of the look-up out from a central host to the edge of the system, or the reader. The predominant topology circa 2009 is hub and spoke with a control panel as the hub, and the readers as the spokes. The look-up and control functions are by the control panel. The spokes communicate through a serial connection; usually RS-485. Some manufactures are pushing the decision making to the edge by placing a controller at the door. The controllers are IP enabled, and connect to a host and database using standard networks

Access control readers may be classified by the functions they are able to perform

and forward it to a control panel.

Basic (non-intelligent) readers: simply read

Semi-intelligent readers: have all inputs and outputs necessary to control door hardware (lock, door contact, exit button), but do not make any access decisions. When a user presents a card or enters a PIN, the reader sends information to the main controller, and waits for its response. If the connection to the main controller is interrupted, such readers stop working, or function in a degraded mode. Usually semi-intelligent readers are connected to a control panel via an RS-485 bus.

Intelligent readers: have all inputs and outputs necessary to control door hardware; they also have memory and processing power necessary to make access decisions independently. Like semi-intelligent readers, they are connected to a control panel via an RS-485 bus. The control panel sends configuration updates, and retrieves events from the readers.

Systems with IP readers usually do not have traditional control panels, and readers communicate directly to a PC that acts as a host

a built in webservice to make it user friendly

Some readers may have additional features such as an LCD and function buttons for data collection purposes (i.e. clock-in/clock-out events for attendance reports), camera/speaker/microphone for intercom, and smart card read/write support

You can perform the following tasks from the Script Editor.

pening, deleting, renaming, and saving scripts

Cutting, copying, and pasting text

Find and replace

Setting a time zone

scripts with time-based triggers

Running functions

Viewing log messages

revision history

write pseudocode first

When you're planning a script

narrative version of what the script needs to do.

A particular script is associated with one and only one Google Spreadsheet.

If you make a copy of the Spreadsheet, the script is also copied.

A particular Spreadsheet can have multiple scripts associated with it.

use the onOpen event handler in more than one script associated with a particular Spreadsheet, all scripts begin to execute when you open the Spreadsheet and the order in which the scripts are executed is indeterminate.

event handler is a function executed when a particular event takes place.

see Running Scripts in Response to an Event.

A script cannot currently call or create another script and cannot call functions in another script.

If you want to store the results of a function, you must copy them into a spreadsheet cell.

You can trigger Apps Script events from links that are embedded in a Google Site. For information about how to do this, see Using Apps Scrip in Your Ssite.

You can insert a script into a Site as a gadget.

you must grant permission for the script to run as a service.

You also designate whether only you can invoke the service or whether all members of your domain can invoke the service.

you can assign functions within the script any arbitrary name.

The instructions in a function must be enclosed within curly braces.

event handler

when a spreadsheet is opened,

when a script is installed

when a spreadsheet is edited

at times you choose

menu item

Using a drawing or button embedded in a Spreadsheet

Using a custom function that is referenced as a Spreadsheet function

Clicking the Run button

object-oriented programming languages

Google Apps Script uses the JavaScript language.

Operations

are performed using the objects and methods described in the API documentation.

An API provides pre-packaged code for standard tasks you need to accomplish in scripts or programs.

API includes objects that you use to accomplish tasks such as sending email, creating calendar entries

A method describes the behavior of an object and is a function attached to an object.

MailApp

use to create and send email

To send email, you invoke the sendEmail method and provide values for the method arguments.

Google Apps Script can access or retrieve data in different formats in different ways.

A custom function

is called directly from a cell in a Spreadsheet using the syntax =myFunctionName()

they cannot set values outside the cells

have some restrictions not shared by other functions

cannot send email

cannot operate on a Google Site

cannot perform any operations that require user authorization

cannot perform any operations that require knowledge of who the user

onInstall function

onOpen function

Other functions run when you run them manually or when they are triggered by clicking

Custom functions and formulas in the spreadsheet execute any time the entire Spreadsheet is evaluated or when the data changes in the function or formula's cell.

share the Spreadsheet

publish the script to the Script Gallery

spreadsheet template

the color coding for that line will not be correct

A script with incorrect syntax or other errors does not run.

The Script Editor includes a debugger.

view the current state of variables and objects created by a script while that script runs.

step through the code line by line as it executes or set breakpoints

The debugger does not work with custom functions, onEdit functions, event triggers, or scripts running as a service.

use the debugger to find errors in scripts that are syntactically correct but still do not function correctly.

Functions ending in an underscore (_), for example, internalStuff_(), are treated differently from other functions. You do not see these function in the Run field in the Script Editor and they do not appear in the Script Manager in the Spreadsheet. You can use the underscore to indicate that users should not attempt to run the function and the function is available only to other functions.