with Scott
with Scott
  • 1
  • 31 988
Notion Birthday calendar
If you have a contact database in Notion and you store their date of birth, then you need a way to view upcoming birthdays. This video shows you a formula method you can use to do just that.
Formulas used:
dateBetween(now(), prop("DOB"), "years") : current age of a person
dateAdd(prop("DOB"), prop("Age") + 1, "years") : upcoming birthday date
prop("Age") + 1 : age at upcoming birthday
Note: the formulas above do not show the birthday on it's actual day. The formula below caters for this:
if(dateBetween(dateAdd(prop("DOB"), prop("Age"), "years"), now(), "days") == 0, dateAdd(prop("DOB"), prop("Age"), "years"), dateAdd(prop("DOB"), prop("Age") + 1, "years"))
Template link:
www.notion.so/Home-a5ba0aff2c414ffab3e6394a47a6452f
มุมมอง: 31 990

วีดีโอ

ความคิดเห็น

  • @PriyankaBKhandvi
    @PriyankaBKhandvi 4 หลายเดือนก่อน

    please make more creative videos like this. I would love to use this techniques in my notion.

  • @PriyankaBKhandvi
    @PriyankaBKhandvi 4 หลายเดือนก่อน

    This is exactly what I was looking for! I'm really grateful to you. thanks again! you've got a new fan!

  • @ZlataZKulish
    @ZlataZKulish 5 หลายเดือนก่อน

    Thank you so much! This is exactly what I was looking for!

  • @andrelucasdeoliveiramoreir3958
    @andrelucasdeoliveiramoreir3958 5 หลายเดือนก่อน

    How can I arrange to notify myself on the client's birthday?

  • @zpartoredjo
    @zpartoredjo 6 หลายเดือนก่อน

    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"))

  • @CamilaFrey
    @CamilaFrey 7 หลายเดือนก่อน

    how can I make sure it updates itself every year? thank you so muchh

  • @CamilaFrey
    @CamilaFrey 7 หลายเดือนก่อน

    You are amazing Thank you so much!!!!!!!!!!

  • @TheOkever
    @TheOkever 9 หลายเดือนก่อน

    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!!

  • @vicentegastonmunoz5597
    @vicentegastonmunoz5597 9 หลายเดือนก่อน

    Thank you so much!

  • @sashachan6556
    @sashachan6556 9 หลายเดือนก่อน

    I appreciate this tutorial 👍

  • @CeciliaRamirez-r9l
    @CeciliaRamirez-r9l 10 หลายเดือนก่อน

    Amazing!!!1

  • @LeoJahn182
    @LeoJahn182 11 หลายเดือนก่อน

    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! 😁😁

  • @3969sjsjwbsjsisjen
    @3969sjsjwbsjsisjen ปีที่แล้ว

    The video was helpful & Thanks for the Formula in the description also !!!

  • @Steinchenklemmer
    @Steinchenklemmer ปีที่แล้ว

    Thank You for this Tutorial

  • @Tico_Rodrigues7
    @Tico_Rodrigues7 ปีที่แล้ว

    Obrigado pelo Templete! 🙌

  • @MRRRR96
    @MRRRR96 ปีที่แล้ว

    Amazing tutorial, thank you so much for this!!

  • @sylvietas
    @sylvietas ปีที่แล้ว

    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.

  • @zeniavalle8698
    @zeniavalle8698 ปีที่แล้ว

    MIL GRACIAS JUSTO LO QUE ESTABA BUSCANDO

  • @bagwellgaming3979
    @bagwellgaming3979 ปีที่แล้ว

    Very helpful video. Thanks a ton

  • @speakacademyespana
    @speakacademyespana ปีที่แล้ว

    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!

  • @by_nayha
    @by_nayha ปีที่แล้ว

    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 <3<3 (i'm a native spanish speaker)

  • @ricardohernandez5666
    @ricardohernandez5666 ปีที่แล้ว

    Perfect explaination, I was looking to make this calendar for a long time and never figured out

  • @shimmeringlight4036
    @shimmeringlight4036 ปีที่แล้ว

    Thank you so much for sharing this, love it! Subscribed!

  • @janeenhernandez5077
    @janeenhernandez5077 ปีที่แล้ว

    Is it possible to add birthdays and tasks to the same calendar?

  • @brandonkinsey6390
    @brandonkinsey6390 ปีที่แล้ว

    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!

  • @kustomkure
    @kustomkure 2 ปีที่แล้ว

    Reminders would be a good addition here

  • @birdyala
    @birdyala 2 ปีที่แล้ว

    Thanks a million!! 💞

  • @ourbalconygarden
    @ourbalconygarden 2 ปีที่แล้ว

    Hi Scott ! Thanks for the detail description. can you plese let know how to add birthday reminder in this birthday calender ?

  • @romylagrand5436
    @romylagrand5436 2 ปีที่แล้ว

    I can't press on done? :( help

  • @encorebeautification
    @encorebeautification 2 ปีที่แล้ว

    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.

  • @DanyhzVideos
    @DanyhzVideos 2 ปีที่แล้ว

    Doesnt work for birthdays coming THIS year... it only indicates birthdays coming next year, not a good option tbh

  • @zanenakama1368
    @zanenakama1368 2 ปีที่แล้ว

    Is there a way to set up reminders alongside the birthday event calendar?

  • @magpasulke0789
    @magpasulke0789 2 ปีที่แล้ว

    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?

  • @tec6717
    @tec6717 2 ปีที่แล้ว

    Thanks for this, helped a lot!

  • @Napopixie
    @Napopixie 2 ปีที่แล้ว

    Thank you, thank you and a 1000 thank you!!! I need this rlly bad, it works perfectly!!

  • @johnduque3486
    @johnduque3486 2 ปีที่แล้ว

    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.

  • @greyshadow2636
    @greyshadow2636 2 ปีที่แล้ว

    Amazing ✨🖤

  • @yaroslavboretsky3146
    @yaroslavboretsky3146 2 ปีที่แล้ว

    Dude, thank you so much! You're amazing! Helped me a loot!

  • @evilmarc
    @evilmarc 2 ปีที่แล้ว

    How do I get the calendar to populate if I only know the year of birth for some of my contacts?

  • @jentevanderveen5780
    @jentevanderveen5780 2 ปีที่แล้ว

    This is awesome. Thank you!

  • @Nakawashi91
    @Nakawashi91 3 ปีที่แล้ว

    Thank you a lot 🙏

  • @OGabrielRubens
    @OGabrielRubens 3 ปีที่แล้ว

    Thanks man, This was the sipler solution that I have seen! :)

  • @joycepavanelli336
    @joycepavanelli336 3 ปีที่แล้ว

    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.

  • @alexuqt
    @alexuqt 3 ปีที่แล้ว

    Thank you so much!

  • @RageCTRLonline
    @RageCTRLonline 3 ปีที่แล้ว

    Thank you so much! I really like your quiet style and it's really calming while you're teaching us. Bravo!!!!

  • @shriefallam8866
    @shriefallam8866 3 ปีที่แล้ว

    All I can say to Notion is "All you had to do is to remind us of the damn birthday CJ"! XD

  • @oceanbellsbella358
    @oceanbellsbella358 3 ปีที่แล้ว

    simply genius!

  • @henning3518
    @henning3518 3 ปีที่แล้ว

    Hello, is it possible to apply a Birthday Reminder? so that I don`t have to look at the Home page?

  • @thanhthanh5613
    @thanhthanh5613 3 ปีที่แล้ว

    Thank you so much !!!

  • @arnze
    @arnze 3 ปีที่แล้ว

    This is amazing!!