I’ve got a handful of automations that are triggered by updates to specific fields in a table, and when the criteria match a record gets flagged. I’m seeking a solution for how to get a new automation to run where the trigger criteria are met by existing records when I flip it on. Currently, when I set the automation to run, the existing matching records don’t execute without manually updating them.
There are tens of thousands of records in play, I know I could manually trigger it via a checkbox or some other square peg, but the maintenance of it all is becoming a part time job on its own.
Is there a mechanism that yall have found which lets this flow more like opening a spigot and less like doing it twice because some records already match the trigger? Would appreciate any insights.