Google Apps Script - introduction - 0 views
code.google.com/...guide_writing_scripts.html
shared by Tiberius Brastaviceanu on 03 May 11
- No Cached
google script apps Programming javascript tool tools infrastructure
-
Use the Script Editor to write and run scripts, to set triggers, and to perform other actions such as sharing scripts.
- ...69 more annotations...
-
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.
-
A script cannot currently call or create another script and cannot call functions in another script.
-
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 also designate whether only you can invoke the service or whether all members of your domain can invoke the service.
-
API includes objects that you use to accomplish tasks such as sending email, creating calendar entries
-
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.
-
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.