Discussions

Expand all | Collapse all

I'd like to be able to send out an automated email to an employee on the day of their birthday.

  • 1.  I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 04-19-2018 15:10
    I'd like to be able to send an automated email to each employee in our organization on their birthday.  We have their birthdays listed in Base in the format MM-DD-YYYY (04-19-2018).  I'd like this to trigger every year on that specific day.  Any help is greatly appreciated!


  • 2.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 04-19-2018 16:00


  • 3.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 04-19-2018 17:31
    Thanks Dan.  Looks like this would be a great option, but all of the employees aren't registered Base users.  The reminder does not give me the option to send to the employee's email address.  Only options are different "users".


  • 4.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Silver
    Contributor
    Posted 04-19-2018 16:25
    Hi Aaron,

    You can create a formula date field and use the below formula. It will show the current date when your birthday falls. Based on this field you can trigger a notification.
    Date(Year(Today()),Month([Date of Birth]),Day([Date of Birth]))  
    Thanks,
    Gaurav


  • 5.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 04-19-2018 17:30
    Thanks Gaurav.  If I have a birthday associated with each individual resource (employee), what's the best way to configure the above formula to trigger off notifications independently to each affected employee?  Thanks for your help.  I'm learning, but am definitely not a super skilled user.


  • 6.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 04-19-2018 19:47
    Aaron, you would need to have a birthday report go to an internal user by daily Subscription and then then that internal user click a button set a date to today and refresh the report.

    The email would trigger on that date being changed, and the report would filter on people who's birthday is today and the email was not sent today.

    So the report would refresh and you click the next record.

    That will be the only way to semi automate emailing non users.

    Mark


  • 7.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 04-19-2018 19:51
    Thanks Mark!


  • 8.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 02-26-2019 19:24
    You can accomplish this with automations now. Update a birthday trigger date field to today's date and if it matches Gaurav's formula field above then you send a notification email.


  • 9.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 02-26-2019 19:31
    .. I doubt that will work as Quick Base will see that as a multi record update and not a single record notification.


  • 10.  RE: I'd like to be able to send out an automated email to an employee on the day of their birthday.

    Posted 02-26-2019 20:00
    Oh no... could an automation trigger a quickbase action to trigger a notification in a related table?