Problem with this is that the persons bday disappears from view on their actual birthday (because the formula renews it to the following year once midnight hits) For anyone looking to make sure that the birthday still shows ON THE DAY, use this formula: if(formatDate(dateAdd(prop("DOB"), prop("Age"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("DOB"), prop("Age"), "years"), dateAdd(prop("DOB"), prop("Age") + 1, "years"))
I found exactly what I was looking for. Thank you. I actually followed along the whole way and built this for myself. Works great. Well done. Looking forward to other builds. New subscriber here.
Didn't think to do this at first, but just tried it and it works. Go into your birthday contact list and pick the person you want to add a reminder for and open their page and in an empty block type @ and then reminder and the date and time. Comes up as a notification on Notion and also a notification through your phone app. Would be great if we could set a formula to notify us of everyone in our contacts instead of having to do each individually. But this works for now.
Hey - helpful little tip, on Notion if you want to create a heading there are keyboard shortcuts. You can simply type # for H1, ## for H2 & ### for H3 headings and when you click the spacebar, it will transform that line into the heading size - awaiting your text.
Thank You! Thank you deeply! I was weeks, since from the release of notion calendar, I was looking for an answer on how to do exactly what you did here so THANK YOU! 😁😁
Thank you so much!! It helps me so much, i really wanted to make my own Birthday calendar and your tutorial was so need, i'm new using notion and its kinda difficult, but your tutorial its so usseful even for me
It’s very useful!! Do you also know how to show several tables into one calendar??? For example, I want to see birthdays and anniversary days at once on one calendar. What I can do is only to make all data into one table as a database?
How do I set the right date, for example if you write a year old on top, it will appear one day earlier, but never the right date? If I put January 1, 2003, the table will show December 31, 2002! If anyone can answer me I would appreciate it.
Great video, thanks a lot. It was really helpfull. I'm looking forward to see more videos later on. Is there a way to have videos about formulas? Keep up your excellent work and thanks for all your help and support you can bring us.
It doesn’t seem to work when the actual date gets here. If the birthday is actually “today” it already shows on the calendar for next year...instead of waiting until the day “today” is over.
I was unable to replicate the formula "as is". The best I could do is "Birthday: Next 30 days", but that leaves out today.The other option is "Birthday: On or after", but you cannot specify the number of days, so it will just give you the whole list.
It finally worked for me. I tried to use the formula from a linked table and it didn´t work. So, you must put the formula in the actual table where the original data is. If anyone has a workaround solution, I´m all ears! Thanks Scott!
Problem with this is that the persons bday disappears from view on their actual birthday (because the formula renews it to the following year once midnight hits)
For anyone looking to make sure that the birthday still shows ON THE DAY, use this formula:
if(formatDate(dateAdd(prop("DOB"), prop("Age"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("DOB"), prop("Age"), "years"), dateAdd(prop("DOB"), prop("Age") + 1, "years"))
I found exactly what I was looking for. Thank you. I actually followed along the whole way and built this for myself. Works great. Well done. Looking forward to other builds. New subscriber here.
How can I put even more likes ?! This is genius! Thank you so much!
I'll power up your like.
This is exactly what I was looking for! I'm really grateful to you. thanks again! you've got a new fan!
Thank you so much! I really like your quiet style and it's really calming while you're teaching us. Bravo!!!!
Obrigado pelo Templete! 🙌
Thank you so much! This is exactly what I was looking for!
How do I add reminders for the upcoming birthdays
Didn't think to do this at first, but just tried it and it works. Go into your birthday contact list and pick the person you want to add a reminder for and open their page and in an empty block type @ and then reminder and the date and time. Comes up as a notification on Notion and also a notification through your phone app. Would be great if we could set a formula to notify us of everyone in our contacts instead of having to do each individually. But this works for now.
Reminders would be a good addition here
Perfect explaination, I was looking to make this calendar for a long time and never figured out
Hey - helpful little tip, on Notion if you want to create a heading there are keyboard shortcuts. You can simply type # for H1, ## for H2 & ### for H3 headings and when you click the spacebar, it will transform that line into the heading size - awaiting your text.
Thank You! Thank you deeply! I was weeks, since from the release of notion calendar, I was looking for an answer on how to do exactly what you did here so THANK YOU! 😁😁
This is a perfect video; direct and super helpful! I couldn't find it this answer else on the internet.
The video was helpful & Thanks for the Formula in the description also !!!
MIL GRACIAS JUSTO LO QUE ESTABA BUSCANDO
please make more creative videos like this. I would love to use this techniques in my notion.
Thank you for sharing the formula with us I have been working on my own PRM and wanted something with birthdays baked into it. Now I can add it!
Thank you so much!! It helps me so much, i really wanted to make my own Birthday calendar and your tutorial was so need, i'm new using notion and its kinda difficult, but your tutorial its so usseful even for me
Hey, that's great! Thank you a lot for putting this up.
Does anyone have an idea how to add reminders to the calculated birthday?
I'm curious too!
You are amazing Thank you so much!!!!!!!!!!
Thank you so much for sharing this, love it! Subscribed!
Amazing tutorial, thank you so much for this!!
I appreciate this tutorial 👍
Thank you, thank you and a 1000 thank you!!! I need this rlly bad, it works perfectly!!
Hello,
is it possible to apply a Birthday Reminder? so that I don`t have to look at the Home page?
Hi Scott ! Thanks for the detail description. can you plese let know how to add birthday reminder in this birthday calender ?
Very Helpful. Thank you!
Simply and genius
Very helpful video. Thanks a ton
Thanks a million!! 💞
Dude, thank you so much! You're amazing! Helped me a loot!
It’s very useful!! Do you also know how to show several tables into one calendar??? For example, I want to see birthdays and anniversary days at once on one calendar. What I can do is only to make all data into one table as a database?
HAHAHAHAHA I’m literally such a nerd for this type of shit but omg thank you so much! This was so helpful!
How do I set the right date, for example if you write a year old on top, it will appear one day earlier, but never the right date?
If I put January 1, 2003, the table will show December 31, 2002!
If anyone can answer me I would appreciate it.
Thank You for this Tutorial
Thank you so so much, more than I expected.
ive been trying to figure this out for the past hour...... thank you soooooo much this is genius!!!
Thanks man,
This was the sipler solution that I have seen! :)
Thank you a lot 🙏
Thank you very very much 🤩🤗
Thanks for this, helped a lot!
Great video, thanks a lot. It was really helpfull. I'm looking forward to see more videos later on.
Is there a way to have videos about formulas?
Keep up your excellent work and thanks for all your help and support you can bring us.
It doesn’t seem to work when the actual date gets here. If the birthday is actually “today” it already shows on the calendar for next year...instead of waiting until the day “today” is over.
I have the same problem ((
You can use formulas from here www.notion.so/Birthdays-c5e03e17333141d5a2209013b45f749e
Касенька - Thank you!
Amazing ✨🖤
Thank you so much, very helpful!
All I can say to Notion is "All you had to do is to remind us of the damn birthday CJ"! XD
This is awesome. Thank you!
Thank you so much !!!
Exactly what I was looking for!
Thank you very much for this!
So useful! Thank you so much!
Is it possible to add birthdays and tasks to the same calendar?
simply genius!
This was really helpful bro, thanks :)
Is there a way to set up reminders alongside the birthday event calendar?
I was unable to replicate the formula "as is". The best I could do is "Birthday: Next 30 days", but that leaves out today.The other option is "Birthday: On or after", but you cannot specify the number of days, so it will just give you the whole list.
How do I get the calendar to populate if I only know the year of birth for some of my contacts?
Muito obrigado!!!! (Thank you for much!!)
Thank you ^^
Thanks for video and template. I cannot add new items to Contacts. Everytime I add new name it disappears... Thanks for help.
How can I arrange to notify myself on the client's birthday?
It finally worked for me. I tried to use the formula from a linked table and it didn´t work. So, you must put the formula in the actual table where the original data is. If anyone has a workaround solution, I´m all ears! Thanks Scott!
Can you give more details on how you did it?
Amazing!!!1
Doesnt work for birthdays coming THIS year... it only indicates birthdays coming next year, not a good option tbh
On my notion the option of adding a filter doesn‘t show up when i click on the three dots...what am I doing wrong?
how can I make sure it updates itself every year? thank you so muchh
This is amazing!!
Thanks from India , was looking for exactly this :) . Could you explain the edited if condition ?
need more notion vids
Thank you so much, I had done everything correctly but I couldn't find a way to display it in the calendar!! Thank you for the tutorial!!
I can't press on done? :( help
Any chance you would be willing to share as a template? Been looking for exactly this!
Glad you liked it Charisse. Here is the link: www.notion.so/Home-a5ba0aff2c414ffab3e6394a47a6452f
Thank you so much!
Thank you so much!