New Rows Don't Trigger!

You may setup a Zap and discover that new rows aren't triggering. Or perhaps they were triggering but all of the sudden stopped triggering. What's going on?

You should double check your Zap's filters to make sure you have selected an Order By field. You can find this where you 'edit options' for the MySQL trigger.

Filters

It is very important that you select a field here. When we query your database we'll only pull a set number of records at a time (since we cannot pull all of them) and with no field to order by we'll most likely get the default ordering.

Your primary key would be an excellent choice here if it is auto incremented. Creation dates are also good candidates as well. But leaving this field empty could lead your Zap to stop triggering on new rows because it can't see them anymore.

Was this article helpful?
0 out of 2 found this helpful