Apologies if this has been answered before - please do direct me to where if so!
I’m in the early stages of scoping a project, for which I would need reminder emails sent automatically from Airtable according to a review date as set in the record. E.g if the review date is on “October 16 2021”, Airtable sends an email on that specific date. However, in looking at the automations, it doesn’t seem to have the functionality to set the “when” to a field - only rudimentary options for “today”, “tomorrow” “is before/after”, “is exact date…” etc.
Am I missing something here, or is there indeed a way to set this functionality? Any help would be appreciated!