Google Sheets built-in "On form submit" trigger

Ask for Help
14

This might seem non-intuitive, but when Glide adds a new row, the changeType will be EDIT (not INSERT ROW)

EDIT: Actually, I should qualify that. In actual fact, when Glide adds a new row the changeType could be EDIT, or it could be INSERT ROW. Which depends on whether or not there are any empty rows at the bottom of the sheet.

  • If there are empty rows, the changeType will be EDIT
  • If there are NO empty rows, the changeType will be INSERT ROW

In general, I avoid using the changeType, and instead take actions based on the sheet that was changed (event.source.getActiveSheet().getName();)

2 Likes