Hey Peter!
Welcome to the Airtable community!
Yes, this is possible.
Assuming your Events table has an Event Date field, you need to create a Formula field in your Events table. Let’s label it Days Until Event
In the formula field, enter the formula
DATETIME_DIFF({Event Date}, NOW(),'days')
This will calculate the difference between the current date/time and the date of the event.
Now, be sure you have either a field with the Clerk’s name and another field with their email OR a Collaborator field. (you can have these fields in your Events table or you can have it another table as long as you use a linked record with a lookup field)
Add data in these fields inside the first record in your Events table to set up, test, and create an automation.
In Automations, create an automation where the Trigger is When record matches conditions
Select your Events table
Add a condition of When ‘Days Until Event’ = 14
or ‘Days Until Event’ = 7
or ‘Days Until Event’ = 2
-Test the trigger
For Actions, choose Send email
In the To field, find your email field and click Insert
In your subject, you can write whatever you want or you can use values from your table
In the Message field, you can use values from your field like:
Hey Person,
It’s Days Until Event days until Event Name!
-Test the action
