The condition is met when at least one record has a field that satisfies the specified criteria among multiple records.
Set Record, Field, Criteria, and Comparison value.
Select the Action you used to retrieve the records.
Select the field that should be evaluated during the comparison.
This parameter does not accept fields that are inside tables.
Note that this parameter does not accept the following field types:
You can select a condition from the following:
Enter the value to compare the field’s value. The parameter accepts the following inputs:
Clicking the Condition Inverter will change the condition to “If no records meet the criteria among all records.”
When this condition is used, the action will occur if all records fail to meet the criteria specified in the “Criteria” and “Comparison Value” parameters.
The record mentioned in the Record parameter may not actually exist. For example, the “Retrieve Records by Providing Conditions in Query” action may return no records that match the specified conditions.
If there are no records, the condition “If at least one record whose field satisfy the condition” will determine that the “condition is NOT satisfied.” On the other hand, the condition “If no records meet the criteria among all records” indicates that the “condition is satisfied.”