Sep 12, 2018 09:10 AM
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?
Sep 12, 2018 09:54 AM
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! :grinning_face_with_smiling_eyes:
Sep 12, 2018 08:38 PM
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!!
Sep 13, 2018 10:25 AM
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:
https://community.airtable.com/t/last-modified-timestamp/8595?u=jeremy_oglesby
Aug 06, 2019 04:07 AM
Hi Jeremy,
you stated that AirTable will cache the record ID as “already acted on”.
Do you have any information about the “lifetime” of that cache?
In our usecase, we maintain an overview of contracts which need to be renewed anually (12 months).
I have a view in place which shows contracts close to their end date, and send out notification emails based on that (AirTable to GMail).
So after extending a contract for another year, the sales person would update the AirTable record with “today”'s date and rely on it showing up in the filtered view in a little more then 11 months again (and thus being notified by mail).
Now, my question: In 11 months’ time, will this record be “new” in the filtered view and trigger the mail zap again?
1000 thanks in advance!
Best regards,
Felix
Aug 06, 2019 07:23 AM
It will still be cached. Zapier stores it forever (so it’s not really a cache). However, our On2Air: Actions product overcomes that limitation and will trigger a many times as needed.