Filters & Field Types

Below is a list of Knack's field types along with your options for the operator value for each.

Field Type	Filters Permitted
Short Text	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Paragraph Text	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Yes/No	is, is not, is blank, is not blank
Multiple Choice	is, is not, contains, does not contain, is any, is blank, is not blank
Date/Time (single date)	is, is not, is during the current, is during the previous, is during the next, is before the previous, is after the next, is before, is after, is today, is today or before, is today or after, is before today, is after today, is before current time, is after current time, is blank, is not blank
Number	is, is not, higher than, lower than, is blank, is not blank
Image	is blank, is not blank
File	is blank, is not blank
Address	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank, near
Name	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Link	is, is not, is blank, is not blank
Email	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Phone	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Rich Text	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Currency	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Auto Increment	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Timer	is, is not, higher than, lower than, is blank, is not blank
Rating	is, is not, higher than, lower than, is blank, is not blank
Text Formula	contains, does not contain, is, is not, starts with, ends with, is blank, is not blank
Signature	is blank, is not blank