You are previewing Google Apps Script, 2nd Edition.
O'Reilly logo
Google Apps Script, 2nd Edition

Book Description

Learn how to create dynamic web applications with Google Apps Script and take full advantage of your Google-hosted services. If you have basic coding skills and some JavaScript experience, this practical book shows you how Apps Script works, and provides step-by-step guidance for building applications you can use right away.

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. Safari® Books Online
    6. How to Contact Us
  2. I. Understanding Google Apps Script
    1. 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
          1. The UiApp Service
          2. The HTML Service
          3. Diving into the HTML Service code
        2. Hello Web App
          1. Publishing options
        3. Hello, Google Sites
      5. Web App Versus Container-Bound
      6. Up and Walking
    2. 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
    3. 3. Building an Interface
      1. What’s in a UI?
      2. It Starts with doGet
      3. Contact Me
        1. Getting Started
          1. Adding style
    4. 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
  3. II. Building Enterprise Applications
    1. 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
    2. 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
    3. 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
    4. 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
    5. 9. Mashup
      1. Directing Email Using Google Forms
      2. Charts in Sites
        1. FinanceApp Chart
        2. Chart from a Spreadsheet
  4. Index
  5. Colophon
  6. Copyright