Conditions
Conditions determine whether subsequent actions in a Flow are performed.
Condition Types
The Automation module supports the following condition types and operators for each field type.
Condition Type If
This condition block contains one or more comparisons combined with AND/OR. The following condition sub-types select what is being compared:
-
If Field - Compares a field/column of the trigger's dataset against a value using an operator, and runs the action when the condition is true. Supported only for the Records Added and Records Updated triggers, this condition type is enabled when a dataset is selected.
-
If Metric - Compares a saved metric of the dataset (not a raw column) against a value using an operator, and runs the action when the condition is true. This condition type is supported for all triggers.
-
If Data Load Status - Checks the outcome of a data load and runs the action when the status matches the selected value (Successful, Failed, or Canceled). This condition type is supported only for the Data Load Finish trigger.
Condition Type AND/OR
This condition block contains one or more comparisons combined with AND/OR.
It supports If Field, If Metric, and If Data Load Status conditions, which follow the same rules as in the If condition type.
Operators by Field Data Type
For the If field, the operator list depends on the field’s data type.
Text Fields
| Operator | Description |
|---|---|
| Equals | Matches records with an exact text in the field. |
| Does Not Equal | Excludes records with an exact text in the field. |
| Contains | Matches records with a partial string within the field. |
| Does Not Contain | Excludes records with a partial string within the field. |
| Is Null | Matches records with no value in the field. |
| Is Not Null | Matches records that have a value in the field. |
Numeric Fields
| Operator | Description |
|---|---|
| Equals | Matches an exact number. |
| Does Not Equal | Excludes an exact number. |
| Greater than or equal to | Includes values greater than or equal to the specified number. |
| Less than or equal to | Includes values less than or equal to the specified number. |
| Between Inclusive | Matches values within a range. |
| Is Null | Matches records with no value in the field. |
| Is Not Null | Matches records that have a value in the field. |
Date Fields and Date Groupings
When a condition is applied to a date column, you can set any of the following date groupings:
- Full Date
- Year
- Quarter
- Month
- Week
- Day
For more information, see Date Grouping.
| Operator | Description |
|---|---|
| Equals | Matches an exact date. |
| Does Not Equal | Excludes an exact date. |
| Between Inclusive | Matches dates within a range, including the start and end dates. |
| Before | Matches dates earlier than the comparison date. |
| Before or on | Matches dates earlier than or equal to the comparison date. |
| After | Matches dates later than the comparison date. |
| After or on | Matches dates later than or equal to the comparison date. |
| Is Null | Matches records with no value in the field. |
| Is Not Null | Matches records that have a value in the field. |