How to send birthday notification to user using flow designer.?

Mahesh23 · ‎07-07-2022

Hello community,

Thankyou

Logan Poynter · ‎07-11-2022

Hello,

You are correct that it does return the year, but you can use GlideDate().getDayOfMonthNoTZ() and GlideDate.getMonthNoTZ() capabilities in a scripted action to remove the year and then compare the run start date to the user's birthday to achieve the functionality you're looking for.

@atherakhtar has a script you should be able to reference and make work in this post. Just change the table you're looking at since his example is for HR Profiles.

Please mark my answer as correct/helpful if it has helped you.

Thanks,
Logan
--
LinkedIn

View solution in original post

Logan Poynter · ‎07-07-2022

Hello,

Have your flow run daily, do a records lookup for users with Date of Birth is on Today, then loop over each in a for loop to send your notification from there.

Please mark my answer as correct/helpful if it has helped you.

Thanks,
Logan
--
LinkedIn

Mahesh23 · ‎07-07-2022

Hello, No it won't work bcaz on today condition checks the date, month and year. Not only date and month

OlaN · ‎07-07-2022

Hi,

What (birthday) data do you have available on the sys_user ?

Is the data stored in separate fields [u_birth_year] [u_birth_month] etc,
or in a combined one [u_birthday]?

Mahesh23 · ‎07-07-2022

Hello, Thanks for your response. Combined in one u_birthday field