Can Automatons be Triggered by Date Comparison without a Record Updates?

[Brian_Hendel]

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! : )

[ScottWorld]

Jason:

Good idea - we’ll add this to our formula field reference.

Thanks so much, @Jason! :slightly_smiling_face: Over the last several months, I’ve submitted a ton of suggestions for that formula field reference page through the feedback form at the bottom of that page, but I haven’t seen any updates yet to that page. Do you know if somebody is actively reviewing those submissions? I’ve given a ton of great ideas. :yum:

And yes, what @kuovonne said about TODAY() as well. This was one of my suggestions that I submitted through that feedback form.

[Jason]

kuovonne:

While you are at it, could you also document when TODAY() gets updated?

Sure thing!

ScottWorld:

Do you know if somebody is actively reviewing those submissions? I’ve given a ton of great ideas. :yum:

We do! And thanks for what you’ve submitted. We’re working on dedicating some more resources to article content improvements so we’ll be making changes more often.

[Jeremy_Oglesby]

@Jeremy_Oglesby would find this conversation interesting :winking_face:

[kuovonne]

Jason:

We’re working on dedicating some more resources to article content improvements so we’ll be making changes more often.

Do you have plans for a support portal where users can see a history of all the feedback they’ve provided and status updates? I’m thinking support tickets, beta signups, beta feedback, watched support pages, etc.

Sorry that this is straying from the original topic.

[kuovonne]

@Jeremy_Oglesby So sorry!!! This is the second time this has happened to you. I deeply apologize. My only excuse is that it was late at night and there are too many J names. @JonathanBowen Shoot. This is why I normally don’t tag a bunch of people.

[Jeremy_Oglesby]

No worries, @kuovonne – no need to feel bad. I’m definitely interested in this thread, but you certainly don’t owe it to me to tag me all over the forums. I take no offense whatsoever. I tend to discover forums threads anyhow by sheer brute force of threads read :grimacing: