I’m working on setting up an Airtable automation that needs to locate records with identical date values to the one that triggered the workflow. Whenever a record gets added or modified, I want the automation to search through the table and pull up all entries where the date field contains the exact same value as the triggering record’s date field.
The issue I’m running into is that Airtable’s record finding feature seems limited to fixed criteria or direct field references. I can’t figure out how to make it compare date fields dynamically, like matching {EventDate} with currentRecord.{EventDate}.
Are there any alternative methods to set up this kind of dynamic date matching where the search criteria pulls from the active record’s date value? Would I need to resort to custom scripting for this functionality?