Count the options selected in the specified fields of the table rows matching the specified conditions. You can reuse the result of the count in other Actions.
Count the total number of selections in fields where multiple selections are possible, such as checkboxes and user selections. If there are no selections, it will be zero.
Set Field to Count, How to Count the Same Value, Field for Judgement, Criteria, Comparison Value, and Target Field (Optional).
Select the field in the table to count the selections. This parameter accepts the following field types:
Count same value Separately: Count the number of selections regardless of the selected values.
Count same value as one: Count as one, even if there are two or more rows with the same value selected. This means it will tally the total number of unique values selected.
For example, there are three rows in the table, and the value of the “Field to Count” is as follows:
The results are as follows:
but it counts as one instance.
Select the fields to be used for condition evaluation from the fields in the table.
Select a criteria from the options.
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 rows in the table that meet the criteria, the result will be zero. Also, if there are no rows in the table, the result will be zero.
You cannot select the action for “when there are no rows that meet the conditions” such as “Calculate Average of Fields in Records by Providing Conditions.”