Express Training on Google Form Script and Automation
Published on 20 December 2023
Duration: 30 minutes
Objectives
-
Understand the basics of Google Apps Script in Forms - Learn how to access the script editor and execute a command via a trigger
Time-out
-
Introduction to Google Form Script(5 min)
-
Quick overview of Google Form Script - Presentation of the main features
-
-
Creation of a Google Form and an associated Script(5 min)
-
Creating a simple form with Google Forms - Introduction to the associated script editor
-
-
Execute an instruction(10 min)
-
"On start" trigger configuration - "On submit" trigger configuration - Writing a script to execute an instruction - Quick tests to verify correct operation in the log
-
-
Analysis of Results and Best Practices(10 min)
-
Verification of the results of executing an instruction - Discussion on a script example and how automation can save time
-
Prerequisites
-
Have a Google account and access to Google Forms and Google Sheets
Equipment
-
Computer with a web browser and internet connection
Note
This express training provides a quick introduction to automation with Google Form Script. For a more in-depth understanding, longer training courses are recommended.
1 - Introduction to Google Form Script
Slide 1: Quick Overview of Google Form Script
-
Google Form Script is a scripting platform integrated into Google Forms. - It allows for the addition of custom features and the automation of tasks.
Slide 2: Presentation of main features
-
Script Editor: The built-in script editor for writing Google Apps Script scripts. - Triggers: Events such as "on submit" that activate the execution of scripts.
Slide 3: Advantages of using Google Form Script
-
Customization: Create custom forms with unique features. - Automation: Automate actions in response to form submissions. - Integration: Integrate scripts with other Google services for a richer experience.
Note for the presenter:
These features offer considerable potential for customizing and automating forms. The remainder of this training will explore the creation of specific scripts and automations in more detail.