Ferreira J. Google Apps Script: Web Application Development Essentials

2nd Edition. — O’Reilly Media, 2014. — 215 p. — ISBN10: 1491946180, ISBN13: 978-1-491-94618-3.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.Apps Script is handy for automating Google Apps tasks, but it also serves as a complete application platform. With this book, you’ll learn how to build, store, run, and share data-driven web apps right on Google Drive. You’ll have access to complete code and working examples that show you how everything fits together.Build an interactive Web App UI that runs on most web and mobile browsers;
Create a sample product catalog that displays custom data from a spreadsheet;
Develop an application to generate web forms from templates;
Use Apps Script to build a simple web-based database application;
Design a document workflow builder that users can quickly customize;
Create a Google form that lets you select and send email responses;
Debug your code and keep track of script problems after deployment.Формат книги совместим с iPAD и Amazon Kindle, на PC открывается многими бесплатными ридерами, например Cool Reader, Calibre, Adobe Digital EditionsUnderstanding Google Apps ScriptFirst 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
Hello Web App
Hello, Google Sites
Web App Versus Container-Bound
Up and WalkingSetting 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 UpBuilding an Interface
What’s in a UI
It Starts with doGet
Contact MeAdding 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 DataBuilding Enterprise ApplicationsDynamic Details: A Sites App Using HTML, CSS, and jQuery
Fighting ClutterWhat You Will LearnSupplies
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 CodeAutomate Your Forms and Templates: A Web App for DriveWhat You Will LearnSupplies
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 CodeCollecting Data: A UiApp-Style Web App
The Installed App Has DiedWhat You Will LearnSupplies
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 CodeDocument Workflows
Building a Modern Email WorkflowWhat You Will LearnSupplies
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 CodeMashup
Directing Email Using Google Forms
Charts in Sites
FinanceApp Chart
Chart from a Spreadsheet