Yep, you can definitely do this. A “View” is a filtering of records within a table to show only a particular set.
Let’s say you create a view that filters to show only records who’s renovation dates are on or after today:
If a record’s renovation date changes, such that it now shows up in this view because it is no longer filtered OUT of that view, then Zapier considers that a “New record in View”.
Here’s the catch:
Zapier CACHE’s that record’s ID as having been acted on as a new record in that view already. If that record LEAVES the view (gets filtered out due to another date change), but then later RE-ENTERS that view, Zapier will NOT act on it again - it will recognize the record ID as having already been acted on (zapped).
Hopefully that points you in the right direction. The point of it all is that it is possible to do the kinds of things you are wanting to do – you just have to be clever and careful with your use of views & filters, and how you set it all up. You have to think through all the implications of the system you set up before relying on it in live use.
Happy to answer further questions if you have them!