I set up a Zap as follows:
- Trigger: New/updated record in Airtable filtered view (based on a Last Modified column that only reflects changes to a checkbox column that sends the record into a filtered view)
- Tasks: Create Google Doc from Template + Delay 45 minutes (so I could manually check them all for this first round) + Create Draft in Gmail with PDF of Google Doc attached.
This Zap worked marvelously for 99/105 records that I sent into this filtered view. It, however, did not “catch” the first 4 triggers, so I was left with 4 Google Docs and Gmail drafts that were not created at all.
I’m trying to understand why this was the case. I checked the 105 boxes sequentially one after another, and they all show the same Last Modified time in Airtable. What can I do to make sure that it doesn’t miss the first few records? I didn’t do anything differently for those, and I really don’t want to have to manually check each time.
Image of the checkbox and Last Modified column for the first several records of my filtered view. The first 4 rows did not go through the Zap, the remainder did.
