Google Apps Script, 2nd Edition

Table of Contents

1. Preface
   1. Who Should Read This Book
   2. What You Will Need
   3. Conventions Used in This Book
   4. Using Code Examples
   5. O’Reilly Safari
   6. How to Contact Us
2. I. Understanding Google Apps Script
3. 1. First Steps in Google Apps Script
   1. Google Apps Script Is…
   2. What You Will Get from This Book
   3. Getting Started
      1. Looking Around the Editor
   4. Three Ways to Create a UI
      1. Hello Container-Bound Apps
      2. Hello Web App
      3. Hello, Google Sites
   5. Web App Versus Container-Bound
   6. Up and Walking
4. 2. Setting Up Your Development Environment
   1. How to Debug and Test
      1. Handling Errors and Breaks
      2. Break and Report
   2. Production Error Logging
      1. Logging the Backend
      2. Logging HTML Frontends
   3. Wrapping Up
5. 3. Building an Interface
   1. What’s in a UI?
   2. It Starts with doGet
   3. Contact Me
      1. Getting Started
6. 4. Adding Actions
   1. Handling User Actions
   2. Anatomy of a Handler
   3. The Concept of the Callback
   4. Functions Are Where the Action Happens
   5. Storing the Values
      1. Storing in a Spreadsheet
      2. Setting Up the Spreadsheet
      3. Setting Up the Data
7. II. Building Enterprise Applications
8. 5. Dynamic Details: A Sites App Using HTML, CSS, and jQuery
   1. Fighting Clutter
   2. What You Will Learn
   3. Supplies
   4. Application Overview
   5. Image File Repository
      1. Setting Up the Database
      2. Loading the Database
   6. Creating Pages from a Spreadsheet
      1. Using the Public Google Apps Script Objects Class
      2. Using JavaScript Objects
      3. Installing an Open Source Library
      4. Creating Pages and Filling the Spreadsheet
   7. Creating the Products UI
      1. Displaying Products
      2. Creating the Products Table
      3. Adding Action
      4. Mousing Around
   8. Delivering the Application
   9. Final Code
9. 6. Automate Your Forms and Templates: A Web App for Drive
   1. What You Will Learn
   2. Supplies
   3. Application Overview
   4. Setting Up the Template
   5. Building the Script
      1. UI Setup
      2. Selecting the Template
      3. Getting the Keys
      4. Generating the Form
      5. Submitting the Completed Form
      6. Copying the Template and Adding Responses
      7. Final Code
10. 7. Collecting Data: A UiApp-Style Web App
    1. The Installed App Has Died
    2. What You Will Learn
    3. Supplies
    4. Application Overview
    5. Setting Up
    6. Building the Foundation
       1. Main Panel
       2. Headers Grid
       3. Branding
       4. Search Component
       5. Navigation Component
       6. Content Area
       7. Search View
       8. Creating the Data Store
    7. Configuring Fusion Tables Access
       1. Getting Data from a Fusion Table
       2. Loading the Data in the UI
       3. Adding Client-Side Handlers
    8. Viewing a Record
       1. Fetching the Correct Record
       2. Custom Formatting
       3. Formatting a listBox
    9. Editing a Record
    10. Saving Changes
    11. Inserting a New Record
    12. Deleting a Record
    13. Full Code
11. 8. Document Workflows
    1. Building a Modern Email Workflow
    2. What You Will Learn
    3. Supplies
    4. Application Overview
    5. Creating the Menus
    6. Loading the Sidebar
    7. Starting the Workflow
       1. Start Workflow HTML
       2. Start Workflow JavaScript
       3. Using ScriptDB
       4. Adding Approvers
       5. Loading the Approvers
       6. Removing Approvers
       7. Pressing Start
    8. Recording Approvals
    9. Approval Status
    10. Audit History
    11. Resetting Everything
    12. Deploying Using Add-ons
    13. Finishing Up
    14. Full Code
12. 9. Mashup
    1. Directing Email Using Google Forms
    2. Charts in Sites
       1. FinanceApp Chart
       2. Chart from a Spreadsheet
13. Index