You can filter number fields to let an automation continue only when an amount, a quantity, or a counter is in the range you need. Number filters compare the field's current value with the value you set.
You can use number filters for many things, including:
Sending an approval request only when an expense is over 5,000 EUR.
Creating a purchase task only when the stock of a solar component drops below 20.
This page covers these field types: number, calculation, and unique ID.
Note:
Calculation fields can hold text or dates too. The options you see depend on what the calculation returns.
Unique IDs have no change check.
Has changedisn't available for them.
Who can use filters on number fields?
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 app is in and haveFull accessto every app the automation uses. App permissions alone aren't enough.
Add a filter on a number field
To filter a number field:
Open the database app on desktop or web, click the automations icon in the top bar (tooltip
Create and view automations), then open an automation.Under
And if the following conditions are met, selectAdd filter.In the new row, select the field and choose the number, calculation, or unique ID field.
Select the option and choose how to compare (listed under Options for number fields).
Enter the number. You can also insert a value from another field.
Select
Save changes.
Options for number fields
For number fields, you can choose from these options:
=(equal to) and≠(not equal to) check whether the number equals the value.>(greater than) and<(less than) check against the value, without the value itself.≥(greater than or equal to) and≤(less than or equal to) check against the value, including the value itself.Is emptyandIs not emptycheck whether a number is set. A0counts as a number, soIs emptyisn't met.Has changedchecks whether the number was edited in this update. It's only offered with the triggerWhen a record is updated. Learn more →
For calculation fields, the options depend on what the calculation returns:
For a number:
=,≠,<,>,≤,≥,Is empty, andIs not empty.For text:
Is,Is not,Contains,Does not contain,Starts with,Ends with,Is empty, andIs not empty.For a date:
Is,Is not,Is before,Is after,Is empty, andIs not empty.With the trigger
When a record is updated, each of them also offersHas changed.
For unique ID fields, you can choose =, ≠, <, >, ≤, ≥, Is empty, and Is not empty. Use = for one ID, or ≥ to include every record from a number onward.
Let's look at an example
Let's say a finance team wants a second look at big expenses. Here's how:
Set the trigger to
When a record is createdinExpenses.Add the filter
WhereAmount>5000.Select
Add action→Add comment. The step appears asAdd a comment to the current record. Enter "Needs approval: " and insert theVendorfield.Select
Create automation.
The next time someone books an expense above 5,000, you should see the comment on the record!
Number filter errors
If a filter row is incomplete, or uses a field that no longer exists, the editor marks it in red and the status below the automation's name shows
Broken. Complete or remove the row, then selectSave changes.If a filter matches every record, check the value. A number that comes from a field and is empty at run time can match every record. See My filter doesn't match →.
Use
Is emptyto find records with no number in the field. An empty number field acts like0for<,>,≤, and≥, but not for=. AddIs not emptyto leave out empty fields.
Test, pause, edit, or delete a filter
To test a filter, change a test record so it matches the condition, then click
▷next toManual runat the top right of the editor (tooltipView all runs) to openRuns. In aManual run, no field has changed, soHas changeddoesn't 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, click
•••at the end of the row or group, then selectRemove. SelectSave changes.
Learn more
FAQs
How do I check that a number is between two values?
How do I check that a number is between two values?
Add two filters in the same list: ≥ the lower value and ≤ the upper value. Both have to be met.
Can I compare a number with another field?
Can I compare a number with another field?
Yes! Insert the other field as the value. If that field is empty on a record, the condition can match every record, so check for Is not empty first. Learn more →
Why can't I filter a calculation field with the options I expect?
Why can't I filter a calculation field with the options I expect?
The options follow what the calculation returns. A number offers =, <, >, and the other number options. Text offers Contains, Starts with, and more. A date offers Is before and Is after. Learn more →
Can I filter on a unique ID?
Can I filter on a unique ID?
Yes! Use = for one ID, or ≥ to include every record from a number onward.
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 →
