Google Apps Script - introduction - 0 views
code.google.com/...guide_events.html
google script apps Programming javascript tool tools infrastructure

-
script that you want to run every day at a specific time
-
Google Apps Script provides simple event handlers and installable event handlers, which are easy ways for you to specify functions to run at a particular time or in response to an event.
- ...39 more annotations...
-
Calendar, Mail and Site are not anonymous and the simple event handlers cannot access those services.
-
Installable event handlers are set on the Triggers menu within the Script Editor, and they're called triggers in this document.
-
The spreadsheet containing the script does not have to be open for the event to be triggered and the script to run.
-
You can connect triggers to one or more functions in a script. Any function can have multiple triggers attached. In addition, you can add trigger attributes to a function to further refine how the trigger behaves.
-
When a script runs because of a trigger, the script runs using the identity of the person who installed the trigger, not the identity of the user whose action triggered the event. This is for security reasons.
-
An event is passed to every event handler as the argument (e). You can add attributes to the (e) argument that further define how the trigger works or that capture information about how the script was triggered.
-
an example of a function that sends email to a designated individual containing information captured by a Spreadsheet when a form is submitted.
-
With Google Apps, forms have the option to automatically record the submitter's username, and this is available to the script as e.namedValues["Username"]. Note: e.namedValues are only available for Google Apps domains and not for consumer Google accounts.