Counts the number selected in the specified field of a record. The count results can be used in another action.
Counts the number of selections in a field that allows multiple selections, such as a checkbox or user selection. If there is no selection, it is 0.
Set Record Selection Action, Field to Count, Equal Count Method, and Field to Set Result (Optional).
From the list of actions, select the action that retrieves the records you want to calculate.
Select the fields you want to count.
You can only select fields that allow multiple selections, such as checkboxes or user selections, not attachment fields.
If you select “Count Same Values Separately”, the number of selections is simply counted regardless of the selected value.
If you select Count Same As One, two or more rows that have the same value will be counted as one, i.e., “how many different values are chosen”.
For example, if you have three records, the value of the field to count is
, then the
will be used as a result.
Specify if you want to set the result of a calculation to another field. You can omit it it if you do not want to set the result directly to the field, but you want to use the result in another action.