You can filter changes to let an automation continue only when a field was edited in this update, or was changed to a certain value. Change filters compare the record with its previous revision.
You can use change filters for many things, including:
Reacting once when a property's status changes to
Under contract, not on every later edit.Starting onboarding only when a candidate's stage was changed to
Hired.
This page covers Has changed, Has changed to, and Has changed to any of.
Note:
Change filters need a previous revision. The change options work with the trigger
When a record is updated. InConditional actions, they also needGet previous valuesabove the condition. With other triggers, addGet previous valuesand compare the field's previous value withIsorIs not.A manual run doesn't change the record.
Has changed tomay not match when you test withManual run. Change a test record instead.
Who can use filters on changes?
Automations are available on all plans: Free, Plus, and Premium. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.
To create, edit, pause, or delete automations, you need to be a
Workspace adminof the workspace the database app is in and haveFull accessto every database the automation uses. App permissions alone aren't enough.
Set up a change filter
To filter on a change:
Open the database app and click the automations icon at the top right (
Create and view automations), then open an automation.Set the trigger to
When a record is updated. The change options aren't offered with other triggers. Learn more →Under
And if the following conditions are met, selectAdd filter.In the new row, select the field and choose the one you need.
Select
Has changed,Has changed to, orHas changed to any of.For the last two, choose the value.
Has changeddoesn't need one.Select
Save changes.
Choose the right change option
Has changedis met when the field's value differs from the value in the previous revision of the record, to any value. It's available for most field types.Has changed tois met when the field changed and the new value is the one you choose. It's available for status, single category, single person, single relation, andLast edited byfields. For the status of task list items, the option is calledItem has changed to.Has changed to any ofis met when the field changed and the new set includes any of the values you choose. It's available for multiple categories, multiple people, and multiple relations fields.
Fields that never change after a record is created, such as Created at, Created by, and unique IDs, don't offer a change option.
Tip: The trigger When a record is updated has its own field list: it starts the automation when any chosen field changes. A change filter then decides what happens next, for example only when the status changed to Done. Learn more →
Check the previous value
There's no option for a change from a value. To react to a change from a value, such as a status that was New:
Use
When a record is updated, or addGet previous valuesand work inConditional actionsafter it.Select the field in the filter row and choose the field under the previous values of the record, for example
Deal previous values, instead of the current one.Compare it with the value you expect, for example
IsNew.
Let's look at an example
Let's say you want the team to see when a deal is signed, but not when it's edited afterwards. Here's how:
Set the trigger to
When a record is updatedandStagehas changedinDeals.Add the filter
WhereStageHas changed toSigned.Select
Add filterand addWhereRegionsHas any ofEMEAandAPAC.Select
Add action→Add a comment to the current record, then enter "Deal signed: " and insert theTitlefield.Select
Create automation.
The next time a deal in one of those regions moves to Signed, you should see the comment on the deal!
Change filter errors
If you can't find a change option while you're setting it up, check the trigger. The change options only appear with
When a record is updated. If you change the trigger later, the automation is markedBroken. Remove the change filter or switch the trigger back, then selectSave changes.If a change filter never matches, check the trigger. The filter under the trigger only has a previous revision with
When a record is updated. With other triggers, addGet previous valuesand compare the previous value withIsorIs not. Learn more →If it matches too often, check whether the filter uses
Isinstead ofHas changed to.
Test, pause, edit, or delete a filter
To test a filter, change a test record so it matches the condition, then select the runs button at the top of the automation (
View all runs) to openRuns. AManual rundoesn't change the record, soHas changedoptions may not match.To edit a filter, open the database app, click the automations icon in the top bar, then select the automation. Change the field, option, or value, then select
Save changes.To delete a filter, select the settings button at the end of the row or group, then select
Remove.
Learn more
FAQs
What's the difference between Has changed and Has changed to?
What's the difference between Has changed and Has changed to?
Has changed matches any edit of the field. Has changed to matches only when the new value is the one you choose.
Why doesn't Has changed to match when I use Manual run?
Why doesn't Has changed to match when I use Manual run?
A manual run doesn't change the record, so there's no change to detect. Change a test record instead.
Can I use Has changed with a trigger other than When a record is updated?
Can I use Has changed with a trigger other than When a record is updated?
No, the change options are only offered with When a record is updated. With other triggers, add Get previous values and compare the field's previous value with Is or Is not in Conditional actions.
Can I check what a field was changed from?
Can I check what a field was changed from?
No, there's no option for a change from a value. In the filter row, choose the field under the previous values of the record, such as Deal previous values, and compare it, as described above.
Which field types support Has changed?
Which field types support Has changed?
Most of them. Unique IDs, Created at, and Created by don't, because their values stay the same.
Where can I find all automation filter options?
Where can I find all automation filter options?
In Automation filters →. It explains how to combine rows and groups and links to the options for each field type.
Are you a developer using the Tape API for automations?
Are you a developer using the Tape API for automations?
The automation API has its own documentation for developers. Full reference: Filters in the developer docs →
Still have questions? Find answers and get help from community experts in the Tape community →
