A feature that tells you Happy Birthday

[_ffwpu]

How can I do a feature that says Happy Birthday to you?

[ThinhDinh]

Create a template that says Happy birthday to {X} and replace {X} by the user’s name.

Have a text component that only shows when user’s birthday is today.

[_ffwpu]

Is there a way? It’s attractive. Could you please inform me more?

[Darren_Murphy]

As @ThinhDinh said, you’ll need a Template Column, and you should also look at Component Visibility.

Read up on those, and have a try at doing it yourself. If you get stuck, come back and show what you have and how far you got, and we’ll help with the next steps.

[Charliem]

Don’t think this will work

When I have attempted in the past it hasn’t worked because their birthday is the year they were born

So if you were to make a visibility TODAY it wouldn’t as the year wouldn’t be 2021

Please let me know if you find a way, thanks

[Robert_Petitto]

You’ll need to use math column that converts the birthdate to a number. I use this formula:

month(birthdate)*100+day(birthdate)

Do the same in a new math column for today:

month(now)*100+day(now)

Then compare the two columns. If equal, then it’s their birthday!

[Charliem]

@Robert_Petitto

month(now)*100+day(now)

WOW THANKS

[Robert_Petitto]

No problem!

[Roldy]

… And do not forget to manage who is born in Feb 29…

[_ffwpu]

Thanks for the good source. I don’t know how to apply it.

[Darren_Murphy]

here…

• Step 1: Math column

• Step 2: Math column

• Step 3: if-then-else column

• Step 4: Template column

• Step 5: Hint component using if-then-else column to drive visibility

• Voila!

[Lucas_Pires]

amazing!