Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automations for Birthday Notifications in Outlook

Topic Labels: Automations
663 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi! I run a travel company and we have lots of client info loaded into airtable, including peoples dates of birth. I want to set it up so that I get a notification in my outlook email on the day it’s one of our clients birthdays. Is this possible? I’ve tried using the date field, but obviously peoples DOBs are in the past, so the dates don’t match up with our current calender to get notifications. Thank you!

1 Reply 1

Hi @James_Wales - you can use a formula field to show the birthday this year:

Screenshot 2020-12-19 at 16.41.20

DATEADD(
  Birthday, 
  DATETIME_DIFF(TODAY(), Birthday, 'years'), 
  'years'
)

This gets the number of years between the birthday and “today” then adds this number of years to the birthday. As an aside, this deals with birthdays on 29th Feb and these are forwarded to the 28th Feb.

Now that you have the date for this year, you can use this in an automation to send an email. Something like “when birthday this year = today”.