Field Types
|
Supported Operators
|
|
Name
|
Contains Not Contains Is Empty Is Not Empty |
|
Single Line, Multi Line, Phone
|
Is
Is Not Is Empty Is Not Empty Contains Not Contains
Starts With
Ends With
|
|
Number, Decimal, Currency, Rating, Formula |
Is
Is Not Is Empty Is Not Empty
Less Than
Greater Than
Less Than or Equal To
Greater Than or Equal To
Between
|
|
Address
|
Contains
Not Contains
Is Empty
Is Not Empty
|
|
Email, Website |
Is
Is Not
Is Empty
Is Not Empty
Starts With
Ends With
|
|
Date, Date-Time
|
Is
Is Not Is Empty Is Not Empty
Less Than
Greater Than
Between
|
|
Time
|
Is
Is Not Is Empty Is Not Empty
Less Than
Greater Than
|
|
Decision Box, Terms and Conditions
|
True
False
|
|
Radio, Dropdown
|
Is
Is Not Is Empty Is Not Empty
Starts With
Ends With
Other Choice Is Not Empty
Is Any Of
Is None Of
|
|
Multiple Choice, Checkbox, Image Choices
|
Contains
Not Contains
Is Empty Is Not Empty Contains Any Of Contains All Of Contains None Of |
|
Matrix
Choice
|
Is
Is Not Is Empty Is Not Empty |
|
Slider
|
Is
Is Not
Less Than
Greater Than
Less Than or Equal To
Greater Than or Equal To
Between
|
|
Signature
|
Is Empty Is Not Empty |
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.