Google Apps Script, Second Edition 아놔.

드디어 봤다.........그런데.......쩜쩜쩜......

아 이걸 어떻게 말해야 하나......ㅜ.ㅜ

저작자는 애썼는데....좀더 신경쓰지 그랬어......

일단 난 비추 한표! 더이상 말하지 않겠어....에이X

Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii

Part I. Understanding Google Apps Script

1. First Steps in Google Apps Script. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Google Apps Script Is… 3

What You Will Get from This Book 4

Getting Started 5

Looking Around the Editor 6

Three Ways to Create a UI 10

Hello Container-Bound Apps 11

Hello Web App 16

Hello, Google Sites 20

Web App Versus Container-Bound 22

Up and Walking 23

2. Setting Up Your Development Environment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

How to Debug and Test 26

Handling Errors and Breaks 26

Break and Report 27

Production Error Logging 28

Logging the Backend 28

Logging HTML Frontends 29

Wrapping Up 32

3. Building an Interface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

What’s in a UI? 33

It Starts with doGet 33

Contact Me 35

Getting Started 35

4. Adding Actions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

Handling User Actions 41

Anatomy of a Handler 41

The Concept of the Callback 43

Functions Are Where the Action Happens 46

Storing the Values 46

Storing in a Spreadsheet 47

Setting Up the Spreadsheet 47

Setting Up the Data 49

Part II. Building Enterprise Applications

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

Fighting Clutter 53

What You Will Learn 55

Supplies 55

Application Overview 55

Image File Repository 55

Setting Up the Database 56

Loading the Database 57

Creating Pages from a Spreadsheet 59

Using the Public Google Apps Script Objects Class 59

Using JavaScript Objects 60

Installing an Open Source Library 60

Creating Pages and Filling the Spreadsheet 62

Creating the Products UI 67

Displaying Products 68

Creating the Products Table 70

Adding Action 72

Mousing Around 73

Delivering the Application 77

Final Code 78

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

What You Will Learn 82

Supplies 82

Application Overview 82

Setting Up the Template 82

Building the Script 84

UI Setup 85

Selecting the Template 87

Getting the Keys 89

Generating the Form 90

Submitting the Completed Form 92

Copying the Template and Adding Responses 92

Final Code 94

7. Collecting Data: A UiApp-Style Web App. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99

The Installed App Has Died 99

What You Will Learn 100

Supplies 100

Application Overview 100

Setting Up 102

Building the Foundation 103

Main Panel 103

Headers Grid 104

Branding 104

Search Component 105

Navigation Component 107

Content Area 108

Search View 109

Creating the Data Store 111

Configuring Fusion Tables Access 112

Getting Data from a Fusion Table 114

Loading the Data in the UI 115

Adding Client-Side Handlers 118

Viewing a Record 119

Fetching the Correct Record 119

Custom Formatting 122

Formatting a listBox 123

Editing a Record 125

Saving Changes 127

Inserting a New Record 128

Deleting a Record 131

Full Code 132

8. Document Workflows. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141

Building a Modern Email Workflow 142

What You Will Learn 142

Supplies 142

Application Overview 142

Creating the Menus 143

Loading the Sidebar 145

Starting the Workflow 147

Start Workflow HTML 147

Start Workflow JavaScript 150

Using ScriptDB 151

Adding Approvers 152

Loading the Approvers 153

Removing Approvers 155

Pressing Start 156

Recording Approvals 158

Approval Status 162

Audit History 166

Resetting Everything 168

Deploying Using Add-ons 171

Finishing Up 171

Full Code 171

9. Mashup. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183

Directing Email Using Google Forms 183

Charts in Sites 187

FinanceApp Chart 187

Chart from a Spreadsheet 191

Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195