Supported fields | Conditions |
Text field/Formula field/Radio/Dropdown/Date | =, !=, <, >, <=, >=, IN, NOT IN, CONTAINS, NOT CONTAINS |
Checkbox | IS CHECKED, IS NOT CHECKED |
Image/Attachment | IS FILLED, IS NOT FILLED |
Conditional operators | Associated action |
| = | The condition is true if the field value exactly matches the specified value. |
!= | The condition is true if the field value does not match the specified value. |
< | The condition is true if the field value is numerically less than the specified value. |
> | The condition is true if the field value is numerically greater than the specified value. |
<= | The condition is true if the field value is less than or equal to the specified value. |
>= | The condition is true if the field value is greater than or equal to the specified value. |
IN | The condition is true if the field value matches any value in a predefined list of values. |
NOT IN | The condition is true if the field value does not match any value in a predefined list. |
CONTAINS | The condition is true if the field value contains the specified substring or value. |
DOES NOT CONTAIN | The condition is true if the field value does not contain the specified substring or value. |
IS CHECKED | The condition is true if a checkbox or radio button field is checked. |
IS NOT CHECKED | The condition is true if a checkbox or radio button field is not checked. |
IS FILLED | The condition is true if the field has any value (i.e., it is not empty). |
IS NOT FILLED | The condition is true if the field is empty (i.e., no value is provided). |
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
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.
All-in-one knowledge management and training platform for your employees and customers.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.