Zapier (Airtable to Slack) when record is updated


#1

Hi there, i use zapier to connect airtable to slack and mostly it is fantastic. Unfortunately, it appears zapier can only be triggered when a new record in a view is created or a new record is created in Airtable.

what i am trying to do is alert slack when a renovation date is updated. So it isn’t a new record or a new record in a view, it is just a cell that is being updated. Any ideas?


#2

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! :smile:


#3

ok! clever, there is something there. i definitely see that this would work for the first time someone enters in the renovation date. but as you mentioned it would not alert it again if someone subsequently changed the date

trying to think how that would work…trying to think how to trigger Zapier when someone just changes the already set reno date?

thank you for the help!!


#4

FWIW, this is a commonly requested feature:



AND, Airtable is aware of the need for a “last-modified” sort of functionality and has stated (albeit, quite a long time ago) that they are working on it: