Google Apps Script 25c2 25b7 Web Application Development Essentials (2nd Edition) by Ferreira, James -- Read -- Imperial Library of Trantor

Index

Google Apps Script Preface

Who Should Read This Book What You Will Need Conventions Used in This Book Using Code Examples Safari® Books Online How to Contact Us

I. Understanding Google Apps Script

1. First Steps in Google Apps Script

Google Apps Script Is… What You Will Get from This Book Getting Started

Looking Around the Editor

Three Ways to Create a UI

Hello Container-Bound Apps

The UiApp Service The HTML Service Diving into the HTML Service code

Hello Web App

Publishing options

Hello, Google Sites

Web App Versus Container-Bound Up and Walking

2. Setting Up Your Development Environment

How to Debug and Test

Handling Errors and Breaks Break and Report

Production Error Logging

Logging the Backend Logging HTML Frontends

Wrapping Up

3. Building an Interface

What’s in a UI? It Starts with doGet Contact Me

Getting Started

Adding style

4. Adding Actions

Handling User Actions Anatomy of a Handler The Concept of the Callback Functions Are Where the Action Happens Storing the Values

Storing in a Spreadsheet Setting Up the Spreadsheet Setting Up the Data

II. Building Enterprise Applications

5. Dynamic Details: A Sites App Using HTML, CSS, and jQuery

Fighting Clutter What You Will Learn Supplies Application Overview Image File Repository

Setting Up the Database Loading the Database

Creating Pages from a Spreadsheet

Using the Public Google Apps Script Objects Class Using JavaScript Objects Installing an Open Source Library Creating Pages and Filling the Spreadsheet

Creating the Products UI

Displaying Products Creating the Products Table Adding Action Mousing Around

Delivering the Application Final Code

6. Automate Your Forms and Templates: A Web App for Drive

What You Will Learn Supplies Application Overview Setting Up the Template Building the Script

UI Setup Selecting the Template Getting the Keys Generating the Form Submitting the Completed Form Copying the Template and Adding Responses Final Code

7. Collecting Data: A UiApp-Style Web App

The Installed App Has Died What You Will Learn Supplies Application Overview Setting Up Building the Foundation

Main Panel Headers Grid Branding Search Component Navigation Component Content Area Search View Creating the Data Store

Configuring Fusion Tables Access

Getting Data from a Fusion Table Loading the Data in the UI Adding Client-Side Handlers

Viewing a Record

Fetching the Correct Record Custom Formatting Formatting a listBox

Editing a Record Saving Changes Inserting a New Record Deleting a Record Full Code

8. Document Workflows

Building a Modern Email Workflow What You Will Learn Supplies Application Overview Creating the Menus Loading the Sidebar Starting the Workflow

Start Workflow HTML Start Workflow JavaScript Using ScriptDB Adding Approvers Loading the Approvers Removing Approvers Pressing Start

Recording Approvals Approval Status Audit History Resetting Everything Deploying Using Add-ons Finishing Up Full Code

9. Mashup

Directing Email Using Google Forms Charts in Sites

FinanceApp Chart Chart from a Spreadsheet

Index Colophon Copyright

← Prev
Back
Next →

← Prev
Back
Next →