E-book details

Google Apps Script for Beginners. Building on your basic JavaScript knowledge, this book takes you into the world of Google Apps Script and shows you how to develop and customize your own apps. The step-by-step approach provides all the necessary skills

Google Apps Script for Beginners. Building on your basic JavaScript knowledge, this book takes you into the world of Google Apps Script and shows you how to develop and customize your own apps. The step-by-step approach provides all the necessary skills

Serge Gabet

Ebook
  • Google Apps Script for Beginners
    • Table of Contents
    • Google Apps Script for Beginners
    • Credits
    • About the Author
    • About the Reviewers
    • www.PacktPub.com
      • Support files, eBooks, discount offers, and more
        • Why subscribe?
        • Free access for Packt account holders
    • Preface
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Downloading the example code
        • Errata
        • Piracy
        • Questions
    • 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 performances
        • Example
      • Catching events
      • Who is doing what? Script authorizations
      • Protecting your data
      • Publishing your data on the Web
      • Printing and exporting the result
      • Summary
    • 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
    • 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 messages
      • Automating a complete workflow
      • Summary
    • 4. Embedding Scripts 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
    • 5. Embedding Scripts in Google Sites
      • Site gadget's limitations/restrictions/use cases
      • Creating and maintaining sites with Google Apps Script
      • Creating pages
      • Interactivity
      • Summary
    • 6. Standalone Web Applications / User Interfaces
      • UI or not UI, that's the question
        • Common 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
    • 7. Using User Interfaces in Spreadsheets and Documents
      • Pop ups
      • Sidebars
      • Summary
    • 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
    • 9. Conclusion
      • Development perspectives
      • Google's secrets
      • Personal point of view
    • Index
  • Title: Google Apps Script for Beginners. Building on your basic JavaScript knowledge, this book takes you into the world of Google Apps Script and shows you how to develop and customize your own apps. The step-by-step approach provides all the necessary skills
  • Author: Serge Gabet
  • Original title: Google Apps Script for Beginners. Building on your basic JavaScript knowledge, this book takes you into the world of Google Apps Script and shows you how to develop and customize your own apps. The step-by-step approach provides all the necessary skills.
  • ISBN: 9781783552184, 9781783552184
  • Date of issue: 2014-02-21
  • Format: Ebook
  • Item ID: e_3b6n
  • Publisher: Packt Publishing