Trigger a Zapier zap based on date

[Graig_Stettner]

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.

[Justin_Barrett]

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.

[Graig_Stettner]

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?

[Justin_Barrett]

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

Graig_Stettner:

Sort of like, if today’s date = dob + 21 years

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:

Airtable Support

Guide to filters and record visibility

One of the core features of views is the ability to filter records according to particular criteria (rows, in grid views). When a record is filtered, it is not deleted—it's just hidden from the par...