Hi! Newbie here! Loving AT to far.
I want to automatically notify my sales team 2 days before a trial is set to expire, so I have a TRIAL START DATE date field, and a DAYS LEFT IN TRIAL formula that does a DATEADD and DATEDIFF to get a days count, that counts from 30 down to zero. That is, your 30-day trial starts today, and every day when I log in to Airtable, I expect the DAYS LEFT IN TRIAL to decrement by one. This all works fine.
My question is, can I create an Automation trigger, based on this DAYS LEFT IN TRIAL, checking for when it reaches 0, and initiates the automation? Note that no actual “update event” happens anywhere in the DB. This is just day by day passage of time. I am worried that the developers of AT would require some kind of database update / change for triggers to get calculated.
Thanks! : )