Google Script: Enterprise Application Essentials

Table of Contents

1. Preface
   1. Introduction
   2. Who Should Read This Book
   3. What You Will Need
   4. Conventions Used in This Book
   5. Using Code Examples
   6. Safari® Books Online
   7. How to Contact Us
2. I. Understanding Google Script
   1. 1. First Steps in Google Script
      1. Google Script Is...
      2. What You Will Get From This Book
      3. Getting Started
      4. Looking Around the Editor
      5. Three Ways to Create a UI
         1. Hello UiApp Spreadsheet Integrated
            1. Diving into the code
         2. Integrated Versus Standalone
         3. Creating a Standalone UI
            1. Publishing a script
         4. Making Google Sites Interactive
         5. Using the GUI Builder
      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
         3. Production Error Logging
      2. Wrapping Up
   3. 3. Building an Interface
      1. What’s in a UI?
      2. It Starts with doGet()
      3. Contact Me
         1. Using the GUI Builder
         2. Handcoding a GUI
   4. 4. Adding Actions
      1. Handling a Handler
      2. Anatomy of a Handler
      3. The Concept of the Callback
      4. Functions Are Where the Action Happens
      5. Verifying the Input
      6. Storing the Values
         1. Store in a Spreadsheet
         2. Setting Up the Spreadsheet
         3. Setting Up the Data
3. II. Building Enterprise Applications
   1. 5. Dynamic Details Using CSS
      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 Script Objects Class
         2. Installing an Open Source Library
         3. Create Pages and Fill the Spreadsheet
      7. Creating the Products UI
         1. Displaying Products
         2. Get the Products
         3. Load the UI
         4. Adding Action
         5. Build the Information Panel
         6. Styled with CSS
      8. Delivering the Application
   2. 6. Automate Your Forms and Templates
      1. What You Will Learn
      2. Supplies
      3. Application Overview
      4. Setting Up the Template
      5. Building the Script
         1. UI Setup
         2. Adding Helpers
         3. Getting the Keys
         4. Generating the Form
         5. Copy the Template and Add Responses
         6. Delivery Options
   3. 7. Collecting Data
      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. Brand It
         4. Loading the Search Component
         5. Controls Component
         6. Content Area
      7. Search View
         1. Creating the Data Store
         2. Importing Public Classes
         3. Getting Data from a Fusion Table
         4. Loading the Data in the UI
         5. Adding Client Side Handlers
      8. Viewing a Record
         1. Fetch the Correct Record
         2. Custom Formatting
         3. Formatting a listBox
      9. Edit a Record
      10. Save Changes
      11. Insert a New Record
      12. Deleting a Record
   4. 8. Workflows
      1. Building a Modern Email Workflow
      2. What You Will Learn
      3. Supplies
      4. Application Overview
      5. Using a Namespace
      6. Building the UI
         1. Application Layout
         2. Entering the Application
         3. Creating a New Workflow
         4. Loading Workflows
         5. Displaying the Workflow Details
         6. Accessing Google Documents
            1. Documents functions
         7. Making Steps
            1. Steps form
            2. Loading the steps
         8. Saving the Workflow
      7. Notification System
   5. 9. Mash Up
      1. Directing Email Using Google Forms
      2. Charts in Sites
         1. FinanceApp Chart
         2. Chart from a Spreadsheet
      3. City, State—List Box Duo
      4. Get Social with Google APIs
      5. Progress Indicators
4. III. UI Element Examples
   1. A. UI Element Examples
      1. Boxes
         1. Check Box
         2. List Box
         3. Password Box
      2. Buttons
         1. Push Button
         2. Radio Button
         3. Reset Button
         4. Toggle Button
         5. Submit Button
      3. File Upload
      4. Flex Table
      5. Grid
      6. Hidden
      7. Anchor (Hyperlink)
      8. Image
      9. Label
      10. Text Area
      11. Text Box
5. About the Author
6. Copyright