Count the options selected in the specified field in the retrieved records. 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 Select Record Action, Field to Count, How to Count the Same 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 count the selections. This parameter accepts the following field types:
Fields in tables cannot be selected.
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 records, and the value of the “Field to Count” is as follows:
The results are as follows:
but it counts as one instance.
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 in the result of the “Record Selection Action”, the result will be zero.
You cannot select the action for “when there are no records” such as “Calculate Average of Fields in Records.”