I have a date field for the start date of my employees and I would like to set up an automation that reminds me after 85 days that their three-month review is coming up. Can someone show me how to set the trigger accordingly?
If you haven’t already, set up a field in your Employees table that tracks how long they have been with the company, then create a view that filters where the ‘# of Days’ field is greater than 85 or alternatively, set the filter to where the start date is more than 85 days ago.
Once you have that set up, create an automation where your trigger is ‘When a record enters a view’, select the new view you just set up.
Then for your action, you can set up an email to be sent to whatever email you’d like from Airtable. Using the ‘Send email’ action and set that up accordingly.