Help

Trigger a Zapier zap based on date

1127 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Graig_Stettner
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to trigger a zap when a date in Airtable equals the current date. Looking at the triggers in Zapier (New Record; New Record in View; New or Updated Record), I don’t see a way to do that. For example, if I have an Airtable comprised of people and their 21st birthday, could a Zap trigger when the date of the 21st birthday matches the current date. I’m having a hard time seeing how any of the three Zapier triggers could do that.

3 Replies 3

Welcome to the community, @Graig_Stettner! :grinning_face_with_big_eyes: A formula field could do the date calculation and output a value to the field when a person hits their 21st birthday. A view could then be configured to only show records with that specific formula field output, which would then allow you to use the “New record in view” trigger in Zapier.

Fantastic!

Sort of like, if today’s date = dob + 21 years then => (A) output a value and (B) configure a view.

Can you direct me to resources where I could learn how to do A and B?

I’m short on time, so I hope I can type fast enough.

I recommend using the DATETIME_DIFF() function. Something like this:

DATETIME_DIFF(TODAY(), {DOB date field}, "years") = 21

That will output a 1 when the DOB is 21 years ago, and a 0 at all other times.

For view filtering, go here: