Cargando…
Google Apps Script for Beginners.
In Detail Google Apps Script is a JavaScript-based programming language that works on the cloud and is 100% free to use. It provides all the tools necessary for Google services to work. Users can easily transfer any data from one service to another, save their important e-mails as files, save and sh...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2014.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- 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.