Standalone Web Applications / User Interfaces | Google Apps Script for Beginners

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Google Apps Script for Beginners

By : Serge Gabet

3.5 (15)

Google Apps Script for Beginners

3.5 (15)

By: Serge Gabet

Overview of this book

Google Apps Script for Beginners

Google Apps Script for Beginners

Credits

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Preface

Free Chapter

Enhancing Spreadsheets

Enhancing Spreadsheets

Spreadsheet functions versus Google Apps Script – how to choose?

Using the development environment – the script editor

Custom spreadsheet functions

Formatting your spreadsheets automatically

Reading and writing data from spreadsheets – best practices and performances

Catching events

Who is doing what? Script authorizations

Protecting your data

Publishing your data on the Web

Printing and exporting the result

Summary

Create and Manipulate Forms

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

Managing an E-mail Account

Managing an E-mail Account

Retrieving Gmail data

Creating labels

Counting, sorting, archiving, and deleting e-mails and threads

Creating e-mail messages

Automating a complete workflow

Summary

Embedding Scripts in Text Documents

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

Embedding Scripts in Google Sites

Embedding Scripts in Google Sites

Site gadget's limitations/restrictions/use cases

Creating and maintaining sites with Google Apps Script

Creating pages

Interactivity

Summary

Standalone Web Applications / User Interfaces

Standalone Web Applications / User Interfaces

UI or not UI, that's the question

Limiting user access

Protecting your data (and your script)

Summary

Using User Interfaces in Spreadsheets and Documents

Using User Interfaces in Spreadsheets and Documents

Pop ups

Sidebars

Summary

How to Expand your Knowledge

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

Conclusion

Conclusion

Development perspectives

Google's secrets

Personal point of view

Index

Index

Summary

If we consider Google Apps Script as a toolbox with plenty of different tools, the tools we introduced in this chapter are probably the most powerful and useful.

There will indeed be many occasions when we may want to execute some simple (or not) tasks without using a full-featured spreadsheet: standalone web apps are the solution. Since they can easily be shared across offices or with other users, they also present us with a good way to preserve our privacy.

It might seem a bit complicated, but after a short while, we get pretty familiar with their structure and simple apps take only a few minutes to write.

Now that we understand this new possibility, why not try to integrate UIs in other documents? That will be the focus of the next chapter.

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Google Apps Script for Beginners

Search

Your notes and bookmarks