Join Scott Simpson for an in-depth discussion in this video Using events and triggers in containers, part of Up and Running with Google Apps Script (2013).
So up until now, we've been using the document ID…to call out to documents or spreadsheets in our scripts.…Or we've just been working with little snippets that do one thing or another.…Now, let's take a look at Events and Triggers which let's you tie your…scripts to documents, kind of the flip side of what we've been doing so far.…Events are actions that happen when the state…of an object changes and App Script can…detect a number of things as you can…see here on the events page of the documentation.…But these…just kind of happen.…So what if I want an event to cause some kind of action or activity?…That's where triggers come in.…
They listen for events and execute a function when that event happens.…There are some basic general Triggers, onInstall, onOpen, and onEdit.…And you can also set up time-based Triggers from the current…Projects Triggers option in the Resources menu in the Script Editor.…Starting from my student information spreadsheet, I'll go up to Tools and…choose Script Editor. Here, I'll choose Spreadsheet and I'll…
- What is Google Apps Script?
- Creating and editing files with Apps Services
- Storing data for your script
- Using events and triggers in containers
- Building custom spreadsheet functions
- Sharing your script as a web app
- Serving JSON or XML from your script
- Publishing your app in the Chrome Web Store