Triggers (onEdit, onOpen) in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the onEdit trigger in Google Sheets?

The onEdit trigger runs a script automatically whenever a user changes a cell in the spreadsheet. It helps automate tasks based on edits.

beginner

When does the onOpen trigger run in Google Sheets?

The onOpen trigger runs a script automatically every time the spreadsheet is opened by a user. It is useful for setup tasks like creating menus.

intermediate

Can onEdit triggers run if a script changes a cell value?

No, onEdit triggers only run when a user manually edits a cell, not when a script changes a cell value.

beginner

How do you create a simple onEdit trigger function in Google Sheets?

You write a function named onEdit(e) in the script editor. Google Sheets automatically runs it when a cell is edited.

beginner

What kind of tasks are good candidates for onOpen triggers?

Tasks like adding custom menus, showing welcome messages, or setting up initial spreadsheet states are good for onOpen triggers.

Which trigger runs when you open a Google Sheet?

A onOpen

B onEdit

C onChange

D onLoad

onOpen runs when the spreadsheet is opened.

What event causes the onEdit trigger to run?

A Script changes a cell

B Spreadsheet opens

C User edits a cell

D Spreadsheet is saved

onEdit runs only when a user manually edits a cell.

Can onEdit triggers detect changes made by scripts?

A Yes, always

B Only if script calls onEdit manually

C Only on weekends

D No, only user edits

onEdit triggers do not run for script-made changes.

What is the correct function name for an onOpen trigger?

A onOpen(e)

B onOpen()

C openTrigger()

D onOpenTrigger()

The function should be named onOpen(e) to receive the event object.

Which trigger is best to add a custom menu when the sheet opens?

A onEdit

B onOpen

C onChange

D onInstall

onOpen is used to add menus when the sheet opens.

Explain how the onEdit trigger works in Google Sheets and give an example of when you might use it.

Think about what happens when you change a cell manually.

Describe the purpose of the onOpen trigger and how it can improve user experience in a spreadsheet.

Consider what you want users to see or have ready when they open the sheet.