Group items tagged

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.