Count the options selected in the fields of the retrieved records matching the specified conditions.
The counted result can be used in another Action.
Set Record, Field to Count, How to Count Same Value, Condition Decision Field, Conditions, Comparison Value.
Open the list of Actions and select the Action you used to retrieve the target records.
Select the field whose selection you want to count. The following field types are available:
You cannot include fields that are within a table.
If you select “Count the same value separately”, the number of selections will be counted regardless of the chosen value.
If you select “Count with one the same value”, even if two or more rows select the same value, they will be counted as one. In other words, we will count “how many different values are chosen”.
For example, if you have three records and the Field to Count values are:
you can get results as follows:
From the fields in the app, select the field you want to use to determine the condition.
The following fields cannot be selected.
You cannot include fields that are within a table.
Choose a comparison method such as “equal to” or “greater than”.
Comparison Value sets the value to compare with the field value. The comparison value can be one of the following values:
If there are no records, the result will be zero. It will not be empty.
The result will be zero if there is more than one record but no selection.