I am currently writing an airtable automation for my organization that is trying to run a script on records that are a certain age (currently thinking week old records).
In order to do so, I was thinking of using the “When a record matches condition” trigger, and using the When field on the Created date for the record, and checking if it is before one week ago.
The main point I want to check on is if this is one week from the time when the automation runs, or if this is one week from the time the automation was made. Likewise, how often will this automation run?