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.
Trigger a Zapier zap based on date
+5
+21Welcome 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.
+5Welcome 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?
+21Fantastic!
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.