book

Google Apps Script, 2nd Edition

by James Ferreira

March 2014

Beginner to intermediate

216 pages

4h 59m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Who Should Read This BookWhat You Will NeedConventions Used in This BookUsing Code ExamplesO’Reilly SafariHow to Contact Us
Google Apps Script Is…What You Will Get from This BookGetting StartedLooking Around the EditorThree Ways to Create a UIHello Container-Bound AppsHello Web AppHello, Google SitesWeb App Versus Container-BoundUp and Walking
How to Debug and TestHandling Errors and BreaksBreak and ReportProduction Error LoggingLogging the BackendLogging HTML FrontendsWrapping Up
What’s in a UI?It Starts with doGetContact MeGetting Started
Handling User ActionsAnatomy of a HandlerThe Concept of the CallbackFunctions Are Where the Action HappensStoring the ValuesStoring in a SpreadsheetSetting Up the SpreadsheetSetting Up the Data
Fighting ClutterWhat You Will LearnSuppliesApplication OverviewImage File RepositorySetting Up the DatabaseLoading the DatabaseCreating Pages from a SpreadsheetUsing the Public Google Apps Script Objects ClassUsing JavaScript ObjectsInstalling an Open Source LibraryCreating Pages and Filling the SpreadsheetCreating the Products UIDisplaying ProductsCreating the Products TableAdding ActionMousing AroundDelivering the ApplicationFinal Code
What You Will LearnSuppliesApplication OverviewSetting Up the TemplateBuilding the ScriptUI SetupSelecting the TemplateGetting the KeysGenerating the FormSubmitting the Completed FormCopying the Template and Adding ResponsesFinal Code
The Installed App Has DiedWhat You Will LearnSuppliesApplication OverviewSetting UpBuilding the FoundationMain PanelHeaders GridBrandingSearch ComponentNavigation ComponentContent AreaSearch ViewCreating the Data StoreConfiguring Fusion Tables AccessGetting Data from a Fusion TableLoading the Data in the UIAdding Client-Side HandlersViewing a RecordFetching the Correct RecordCustom FormattingFormatting a listBoxEditing a RecordSaving ChangesInserting a New RecordDeleting a RecordFull Code

Building a Modern Email WorkflowWhat You Will LearnSuppliesApplication OverviewCreating the MenusLoading the SidebarStarting the WorkflowStart Workflow HTMLStart Workflow JavaScriptUsing ScriptDBAdding ApproversLoading the ApproversRemoving ApproversPressing StartRecording ApprovalsApproval StatusAudit HistoryResetting EverythingDeploying Using Add-onsFinishing UpFull Code
Directing Email Using Google FormsCharts in SitesFinanceApp ChartChart from a Spreadsheet

Overview

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.