Filter Conditions — Reference
Which conditions a filter offers depends on the column type. This reference maps the two to each other.
A filter is built as Field → Condition → Value, introduced with If.
→ Filtering, Sorting, Grouping
All conditions
| Condition | Meaning |
|---|---|
| equals | Exact match |
| does not equal | Anything except this value |
| contains | Substring occurs |
| does not contain | Substring does not occur |
| is less than | Numeric comparison |
| is greater than | Numeric comparison |
| is before | Chronological comparison |
| is after | Chronological comparison |
| includes any of | At least one of the selected options |
| includes none of | None of the selected options |
| includes all of | All of the selected options |
| is | Person-based comparison |
| is not | Person-based comparison |
| is empty | No value present |
| is not empty | Some value present |
The same conditions as an expression
Internally, a filter is an ApptiveScript expression. The dialog writes it for you — each condition corresponds to a function:
| Condition | Function |
|---|---|
| equals · does not equal | isEqualTo · isNotEqualTo |
| contains | contains |
| is less than · is greater than | smallerThan · greaterThan |
| is before · is after | before · after |
| includes any of · none of · all of | includesAnyOf · includesNoneOf · includesAllOf |
| is · is not (person) | isActor |
| is empty · is not empty | isEmpty · isNotEmpty |
| and · or | logicalAnd · logicalOr |
| does not contain | contains, negated with isFalse |
You never need to know this just to filter. It helps in two places: reading a Formula, and writing a Condition for a block's visibility or a Flow transition — the same names apply there.
Mapping by column type
Text and text-like types
Text, E-Mail, Phone Number, Weblink
| Condition | |
|---|---|
| equals | does not equal |
| contains | does not contain |
| is empty | is not empty |
Numbers
Number, Decimal, Currency
| Condition | |
|---|---|
| equals | does not equal |
| is less than | is greater than |
| is empty | is not empty |
Date
Date, Date and time, Created at
| Condition | |
|---|---|
| equals | does not equal |
| is before | is after |
| is empty | is not empty |
For date fields, you can choose a relative expression instead of a fixed date:
| Expression | Meaning |
|---|---|
| exact date | A specific day |
| today | The current day |
| tomorrow / yesterday | Relative to the current day |
| X days ago | X days in the past |
| in X days | X days in the future |
These are expressions too: today is today(), yesterday is today().subtractDays(1).
Relative filters don't age
A filter with Due on is before today permanently shows overdue entries — without anyone having to maintain it. A fixed date would already be wrong tomorrow.
That's the difference between a view you set up once and one you have to keep touching.
Checkmark
| Condition | |
|---|---|
| equals | does not equal |
| is empty | is not empty |
Single Select
| Condition | |
|---|---|
| equals | does not equal |
| is empty | is not empty |
Multiple Select
| Condition | |
|---|---|
| includes any of | includes none of |
| includes all of | |
| is empty | is not empty |
The difference matters
- includes any of — at least one of the selected options applies
- includes all of — all of the selected options must apply
- includes none of — none of them apply
For tags, includes any of is usually what's meant. includes all of is much stricter and often returns fewer matches than expected.
Links
Link record
| Condition | |
|---|---|
| is empty | is not empty |
Link multiple records
| Condition | |
|---|---|
| includes any of | includes none of |
| includes all of | |
| is empty | is not empty |
Finding data gaps
Customer is empty shows all entries without an assignment — the fastest way to find incomplete records, especially after a CSV import that couldn't establish links.
Person-related types
User, Created by
| Condition | |
|---|---|
| is | is not |
| is empty | is not empty |
Besides specific people, the expression current user is also available as a value.
One view for everyone
Assigned to is current user creates a view that automatically shows each person their own entries. You don't need a separate view per team member.
For Created by, the values Form link and API Credentials can also appear — for entries that didn't come from a human.
Other types
Files, Address, Geolocation, Signature, Internal Link
| Condition | |
|---|---|
| is empty | is not empty |
Calculated types
Use linked value, Calculate sum, Formula
These types can be filtered; the available conditions depend on the result type. A formula with a numeric result behaves like a number.
Cannot be used as a Flow trigger
Calculated fields can be filtered, but they cannot be used as the triggering field in the Entry was changed Flow trigger. → Triggers
Filter groups
You combine multiple conditions with and or or. Groups can be nested.
Three levels maximum
Filter conditions can only be nested 3 levels deep
If you need more, create a helper field of type Formula or Checkmark that captures the complex condition, and filter on that instead.
As long as a condition is incomplete, ApptiveGrid reports All existing filters must be valid and does not apply the filter.
Completeness
This mapping is a guide
This mapping follows the observed behavior of the application. In individual cases, a type may offer an additional condition, or may not offer one listed here.
What the filter dialog actually offers you is always authoritative.