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 Script: Enterprise Application Essentials

Book Description

How can you extend Google Apps to fit your organization’s needs? This concise guide shows you how to use Google Scripts, the JavaScript-based language that provides a complete web-based development platform—with no downloads, configuration, or compiling required. You’ll learn how to add functionality to Gmail, spreadsheets, and other Google services, or build data-driven apps that run from a spreadsheet, in a browser window, or within a Google Site.

If you have some JavaScript experience, getting started with Google Scripts is easy. Through code examples and step-by-step instructions, you’ll learn how to build applications that authenticate users, display custom data from a spreadsheet, send emails, and many more tasks.

  • Learn Google Script’s built-in debugger, script manager, and other features
  • Create a user interface as a pop-up window, a web page, or a Google Sites gadget
  • Use data objects and CSS to build effective product pages
  • Automatically generate web forms from key values you specify in your Google Docs
  • Create a database UI that works as a mobile app and Google Site gadget
  • Use Google Docs and Gmail to create a document revision workflow

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