O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. 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