Hello community. I need your assistance. I possess a database of employees which contains their hiring date. I want to set up a notification to be sent when an employee’s work anniversary is approaching. For instance, the notification should be sent when there are 15 days left until the anniversary.
Could you please help how to do it?
1 Like
hi @Dasha_Zenko
this blog explains a HRM logic I developed to notify people on events like a birthday
In case this feels overwhelming you can take an easy route:
- create a button in your table
- add the notify logic in that button
- create a second column that contains the birthday date minus 15 and call this column notifyDate
- go to advanced options, select disable and put there the following
- notifyDate != today()
- have an automation run every morning to push all buttons, only the active buttons will generate a message.
and the button
the automation
cheers, christiaan
2 Likes
Hi Christiaan;) Actually I did this notification with the help of your article. But I didn’t create a button and button logic 
Thank you a lot, I hope your instruction will help because i see my mistakes!