Count the number of the retrieved records matching the specified conditions. You can reuse the result of the calculation in other Actions.
Set Select Record Action, Field for Judgement, Criteria, Comparison Value, and Target Field (Optional).
Open the list of Actions and select the Action you used to obtain the target records.
Select the field to be used for condition judgment from the app’s fields. Fields in tables cannot be specified.
You can select a condition as referring follows:
Enter the value to compare the field’s value. The parameter accepts the following inputs:
Use this parameter to set the results to another field. You can leave this parameter empty to use the calculation result in another action without setting it to any field.
This parameter accepts the following field types: Fields in tables cannot be selected.
If there are no records that meet the criteria, the result will be zero. If there were no records as a result of the “Select Record Action”, the result will be zero.
You cannot select the action for “when there are no records that meet the conditions” such as “Calculate Average of Fields in Records by Providing Conditions.”