Google apps script for beginners : customize google apps using apps script and explore its powerful features / Serge Gabet ; cover image by Glen Michael Carrie.

Format:

Book

Author/Creator:

Gabet, Serge.

Contributor:

Carrie, Glen Michael.

Series:

Community experience distilled

Language:

English

Subjects (All):

Google Apps.

Web site development--Software.

Web site development.

Application software.

Java (Computer program language).

Physical Description:

1 online resource (178 p.)

Edition:

1st edition

Place of Publication:

Birmingham, England : Packt Publishing Ltd, 2014.

Language Note:

English

System Details:

text file

Biography/History:

Gabet Serge: Serge Gabet has been a professional audio equipment manufacturer for 20 years and is now working for an artistic upper school in Brussels, Belgium as a teacher and Technical Manager. He is also in charge of the Google Apps administration of this school. He develops custom applications using Google Apps Script mainly for his school, though he also works in other areas. He has been designated a Top Contributor by Google since June 2011. He was active on the Google Group Help forum till 2012, then on the Stack Overflow forum (the Google Help Group forum was closed in June 2012), and became a first ranker and an all-time contributor on the Stack Overflow forum a few months back.

Summary:

This book is a simple step-by-step, example-oriented guide with a focus on providing the practical skills necessary to develop and customize apps with Apps Script.If you are an application developer with no knowledge of App Script, and would like to learn to build apps using Google Apps script from scratch, then this book is for you. Basic JavaScript knowledge is required.

Contents:

Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Enhancing Spreadsheets; Spreadsheet functions versus Google Apps Script - how to choose?; An example; The spreadsheet-formula approach; The Google Apps Script approach - a few comments; The Google Apps Script approach - the code; Using the development environment - the script editor; The advantages of autocompletion; Reading the documentation; Custom spreadsheet functions; Formatting your spreadsheets automatically; Menus and custom buttons in spreadsheets

Reading and writing data from spreadsheets - best practices and performancesExample; Catching events; Who is doing what? Script authorizations; Protecting your data; Publishing your data on the Web; Printing and exporting the result; Summary; Chapter 2: Create and Manipulate Forms; What tools do we have?; Forms' limitations; Handling answers; Forms' alternatives; A quick peek at the UiApp and HTML services; Summary; Chapter 3: Managing an E-mail Account; Retrieving Gmail data; Creating labels; Counting, sorting, archiving, and deleting e-mails and threads; Execution time versus time limit

Creating e-mail messagesAutomating a complete workflow; Summary; Chapter 4: Embedding Script in Text Documents; What can be done; Generating a Google document from spreadsheet data using a script; Analyzing, duplicating, and modifying document elements; Using a script to insert an image into a document; Compiling and presenting data from other services; Summary; Chapter 5: Embedding Scripts in Google Sites; Site gadget's limitations/restrictions/use cases; Creating and maintaining sites with GAS; Creating pages; Interactivity; Summary; Chapter 6: Standalone Web Applications / User Interfaces

UI or not UI, that's the questionCommon concepts to all web apps; Building an efficient UI; Building a good-looking UI; Building an amazing UI; Limiting user access; Protecting your data (and your script); Summary; Chapter 7: Using User Interfaces in Spreadsheets and Documents; Pop ups; Sidebars; Summary; Chapter 8: How to Expand your Knowledge; JavaScript versus Google Apps Script; Infinite resources; Being a newbie is, by definition, temporary; Try to find your own best learning method; Summary; Chapter 9: Conclusion; Development perspectives; Google's secrets; Personal point of view; Index

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed March 6, 2014).

ISBN:

9781783552184

1783552182

OCLC:

871189873