Google Script : enterprise application essentials

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 Java 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 5 Preface 9 Introduction 9 Who Should Read This Book 10 What You Will Need 10 Conventions Used in This Book 11 Using Code Examples 11 Safari庐 Books Online 12 How to Contact Us 12 Part聽I.聽Understanding Google Script 13 Chapter聽1.聽First Steps in Google Script 15 Google Script Is... 15 What You Will Get From This Book 16 Getting Started 16 Looking Around the Editor 17 Three Ways to Create a UI 19 Hello UiApp Spreadsheet Integrated 19 Diving into the code 20 Integrated Versus Standalone 21 Creating a Standalone UI 22 Publishing a script 23 Making Google Sites Interactive 25 Using the GUI Builder 25 Up and Walking 27 Chapter聽2.聽Setting Up Your Development Environment 29 How to Debug and Test 29 Handling Errors and Breaks 30 Break and Report 31 Production Error Logging 32 Wrapping Up 33 Chapter聽3.聽Building an Interface 35 What鈥檚 in a UI? 35 It Starts with doGet() 35 Contact Me 37 Using the GUI Builder 38 Handcoding a GUI 40 Chapter聽4.聽Adding Actions 43 Handling a Handler 43 Anatomy of a Handler 44 The Concept of the Callback 44 Functions Are Where the Action Happens 46 Verifying the Input 47 Storing the Values 48 Store in a Spreadsheet 49 Setting Up the Spreadsheet 49 Setting Up the Data 50 Part聽II.聽Building Enterprise Applications 55 Chapter聽5.聽Dynamic Details Using CSS 57 Fighting Clutter 57 What You Will Learn 58 Supplies 59 Application Overview 59 Image File Repository 59 Setting Up the Database 60 Loading the Database 60 Creating Pages from a Spreadsheet 62 Using the Public Google Script Objects Class 63 Installing an Open Source Library 63 Create Pages and Fill the Spreadsheet 64 Creating the Products UI 68 Displaying Products 69 Get the Products 70 Load the UI 71 Adding Action 73 Build the Information Panel 74 Styled with CSS 76 Delivering the Application 80 Chapter聽6.聽Automate Your Forms and Templates 83 What You Will Learn 83 Supplies 84 Application Overview 84 Setting Up the Template 84 Building the Script 85 UI Setup 85 Adding Helpers 88 Getting the Keys 90 Generating the Form 92 Copy the Template and Add Responses 95 Delivery Options 96 Chapter聽7.聽Collecting Data 99 The Installed App Has Died 99 What You Will Learn 100 Supplies 100 Application Overview 100 Setting Up 101 Building the Foundation 102 Main Panel 103 Headers Grid 103 Brand It 104 Loading the Search Component 105 Controls Component 107 Content Area 107 Search View 108 Creating the Data Store 110 Importing Public Classes 112 Getting Data from a Fusion Table 113 Loading the Data in the UI 114 Adding Client Side Handlers 117 Viewing a Record 117 Fetch the Correct Record 117 Custom Formatting 119 Formatting a listBox 121 Edit a Record 122 Save Changes 124 Insert a New Record 126 Deleting a Record 128 Chapter聽8.聽Workflows 131 Building a Modern Email Workflow 132 What You Will Learn 132 Supplies 132 Application Overview 132 Using a Namespace 133 Building the UI 135 Application Layout 135 Entering the Application 137 Creating a New Workflow 138 Loading Workflows 139 Displaying the Workflow Details 140 Accessing Google Documents 141 Documents functions 145 Making Steps 147 Steps form 149 Loading the steps 152 Saving the Workflow 162 Notification System 167 Chapter聽9.聽Mash Up 171 Directing Email Using Google Forms 171 Charts in Sites 174 FinanceApp Chart 174 Chart from a Spreadsheet 178 City, State鈥擫ist Box Duo 180 Get Social with Google APIs 183 Progress Indicators 186 Part聽III.聽UI Element Examples 191 Appendix. UI Element Examples 193 Boxes 193 Check Box 193 List Box 194 Password Box 195 Buttons 196 Push Button 197 Radio Button 198 Reset Button 200 Toggle Button 200 Submit Button 202 File Upload 203 Flex Table 204 Grid 205 Hidden 207 Anchor (Hyperlink) 209 Image 209 Label 210 Text Area 210 Text Box 210 Annotation How can you extend Google Apps to fit your organizations needs? This concise guide shows you how to use Google Scripts, the JavaScript-based language that provides a complete web-based development platformwith no downloads, configuration, or compiling required. Youll 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 Java experience, getting started with Google Scripts is easy. Through code examples and step-by-step instructions, youll learn how to build applications that authenticate users, display custom data from a spreadsheet, send emails, and many more tasks. Learn Google Scripts built-in debugger, script manager, and other featuresCreate a user interface as a pop-up window, a web page, or a Google Sites gadgetUse data objects and CSS to build effective product pagesAutomatically generate web forms from key values you specify in your Google DocsCreate a database UI that works as a mobile app and Google Site gadgetUse Google Docs and Gmail to create a document revision workflow 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 Java 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