Question

I want to create a feature in my crm that will create a notification of a person's birthday seven days prior to their birthday, and each day until their birthday.

I also need to have a field in the person's record that will store a person's current age.

What is the formula that would allow the age to be calculated and will the formula be recalculated automatically every day?

Answer 1

You can get the age based on a date using this Notion formula.

dateBetween(now(), prop("Date"), "years")

You can't get notifications based on a date unless you use an external service like Make or Zapier to create an automation.

With Notion you can only see the upcoming events for example, but no notifications.