Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

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?

1 Answer

0vote

polle Points77470

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.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect