Hi There,
I am trying to have airtable send me 1 email every 1st of the month with list of ALL people that have birthday in the same “current” month. So if it’s currently Oct now , then I want an email just with those that have birthdays on this month of Oct.
I created a column for the DOB , then another column for the birthday month ( formulated) and another one for “current month” (today’s date).
Seems I am missing something since I am not able to complete the automation part , conditions ask me to refer to a specific value and not another equal “matching field” . so , in other words, I was thinking I’ll be able to trigger the system when the month columns are matching.
*I really wanted to have the email sent 10 days before that 1st of every month but now I feel this is even more complicated . lol. so the 1st will do too.
Any ideas ?
Tnx in advance .