Airtable’s Zapier action “New Record in View” will ONLY trigger if a record appears in the view for the VERY FIRST TIME.
However, if a record falls off the view — and then that very same record returns to the view at a later date — it WON’T trigger the Zapier action again.
We actually need the ability for an automated action to trigger EVERY SINGLE TIME a record re-appears in the view, whether or not the record has appeared in that view in the past.
Meanwhile, It looks like Integromat.com will trigger an action EVERY SINGLE TIME a record is UPDATED (which is a great step in the right direction!), but it doesn’t look like it can monitor just one particular view in Airtable.
We don’t need the automation triggered every single time the record is updated; we just need the automation triggered whenever the record re-appears in a particular view.
[Alternate way of thinking about this problem: Since different views are based on filtering fields, what we’re really looking for is a way to trigger an action when certain fields are changed to certain values (i.e. the record re-appears in the view again). So, another way of looking at this would be that we need triggers based on a matching set of certain field values per record… every time those field values match for a particular record.]
Any ideas on how to accomplish this?