I want to be able to trigger a zap when a Boolean changes from false to true. The problem is that the only zap choice for my Google sheet is ‘new or updated row’ I don’t want it to trigger when the row is created only when a specific cell column/row is changed Boolean false to true. Basically when someone clicks that box of accepted appointment I want it to send a zoom link. Can anyone give me an idea, I keep hearing I should use app script to trigger on edit but I’ve never used app script and it seems like it’s not compatible with the glide Google sheet
You should be able to switch that checkbox to a button that will set the corresponding column to true, and trigger a Zap as a part of a multi-step custom action.