Create and Manipulate Forms | 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

Chapter 2. Create and Manipulate Forms

In January 2013, Google launched a new version of Google forms that was more customizable, richer in many new features, shareable between any number of editors, and—even more important to us—could be created and modified using Google Apps Script.

This feature made it possible to imagine a lot of potential applications. Some of these applications could be used for the following:

To change questions every day, automatically
To modify the form for future respondents based on responses from the past
To remove or add questions depending on any external parameter (such as the day of the week or the time of day)

Visually different images

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