Express Training on Google Form Script and Automation
Published on 20 December 2023
Duration: 30 minutes
Objectives
Understanding the basics of Google Apps Script in Forms Learn to access the script editor and execute an instruction at the trigger
Delay
-
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)
-
Configuration of the trigger "on start - Configuration of the "on submit" trigger - 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 the execution of an instruction - Discussion on a script example and how automation can save time
-
Prerequisite
-
To have a Google account and access to Google Forms and Google Sheets
Material
-
Computer with a web browser and an internet connection
Remark
This express training offers a quick introduction to automation with Google Form Script. For a deeper 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 adding custom features and automating tasks.
Slide 2: Presentation of the main features
-
Script Editor: The built-in script editor for writing Google Apps Script. - Triggers: Events like "on submit" that activate script execution.
Slide 3: Advantages of using Google Form Script
-
Customization: Create custom forms with unique features. - Automation: Automate actions in response to form responses. - Integration: Integrate scripts with other Google services for a richer experience.
Note for the presenter:
These features offer considerable potential for customizing and automating the forms. The rest of this training will explore in greater detail the creation of scripts and specific automations.