Forum Discussion
GauravSharma3
8 years agoQrew Commander
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.
Gaurav
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
- AaronZielinski8 years agoQrew CadetThanks 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.
- QuickBaseCoachD8 years agoQrew CaptainAaron, 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 - AaronZielinski8 years agoQrew CadetThanks Mark!
- JeffKelly17 years agoQrew MemberYou 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.
- QuickBaseCoachD7 years agoQrew Captain.. I doubt that will work as Quick Base will see that as a multi record update and not a single record notification.
- JeffKelly17 years agoQrew MemberOh no... could an automation trigger a quickbase action to trigger a notification in a related table?