I’ve built an automation that is supposed to automatically send an email to people in a base (called ‘Tester panel’) once they’ve been in it for 365 days or more. The date they were added to the base is recorded in the ‘Date added’ field, which is automatically filled in by Airtable:
To set the automation, I picked the ‘When record matches conditions’ trigger, and build it around the ‘Date added’ field in my base:
I tested the automation with mock up records and it works fine. The problem is that when I actually switch it on, it doesn’t send the emails to the database. After a few experiments, I realised that it gets triggered when a new record is added to the base and matches the criteria, but it doesn’t get triggered by the existing records in the base that match the criteria. It seems like either the automation doesn’t work retroactively, or that there’s a problem with the old data in the Date Added field, but I’m not sure what that can be?
I know I could create a view and use the ‘When record enter view’ trigger, but the point of building this automation is to have it do the work for me, and not having to remember to check the base regularly to push records to a view that then triggers the automation…
Any ideas why Date Added is not triggering it?