Hi! I have data coming in from a webhook to Make. I am trying to create a formula in Make to search Airtable for number of times an email appears in a field on a table and limit the number of submissions to Airtable. For example, I want to limit the rows to 5 for this user based on email. When the user submits data via the webhook, I want Make to do a search on Airtable and count the number of time the email appears in the table, if email appears less than 5, allow data to be submitted. If more than 5, give an error or prevent data submission. Here are all the formulas I have tried. 8.FIELD__KPZIT488X is the value from the webhook for email. The query is pulling back the correct number of entries as bundles.
“{{8.FIELD__KPZIT488X}}”={Email}
And I have tried to add a router with condition filter. See attached screenshot. This is were I run into issue of no submitted data to airtable.