We have a “next in line” projects view in which the projects get added manually. I have created an automation that when a project gets updated whilst it is in this view, it gets a certain value. I used the When a record is updated and it seems to work fine. However as the projects get added manually to the view, it seems to trigger directly as the value gets updated when it is newly created. Is there a way to prevent the creation of a new record to trigger the automation?
I tried searching for a workaround but can’t seem to find something.
So project records automatically count the number of applications they get. I would like the automation to kick in when they receive a new application. Some get placed in que when they have 0, others start at 3 applications. Basically I want the automation to check only after it has been put in que.
I also tried “When a record matches condition” trigger with condition applications > 0, but some already start at > 0 so that doesn’t work. I would need something that triggers when application count increases by 1.
Maybe you could add a “last modified” field that only looks at the “number of applications” field for changes. Your automation could then be set to only trigger when that field is modified. When you add a new record via a form, it won’t trigger since the “last modified field” will stay empty.