Google Apps Script - introduction - 0 views
code.google.com/...guide_writing_scripts.html
google script apps Programming javascript tool tools infrastructure
shared by Tiberius Brastaviceanu on 03 May 11
- No Cached
-
Use the Script Editor to write and run scripts, to set triggers, and to perform other actions such as sharing scripts.
-
start the Script Editor from a Google Site
-
declares a function called myFunction()
- ...69 more annotations...
-
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.
