Count the options selected in the specified field in the table. 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, 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.
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, the result will be zero.
You cannot select the action for “when there are no rows in the table” such as “Calculate Average of Fields in Table.”