Count the options selected in the fields of the retrieved records 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, the results will be zero.
Set Select Record Action, Field to Count, How to Count the Same Value, Field for Judgement, Criteria, Comparison 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.
When you select “Count same value separately,” all selections are counted individually, regardless of whether they have the same value.
In contrast, when you choose “Count same value as one,” multiple rows with the same selected value will be counted as just one. 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.
Select the field to be used for condition judgment from the app’s fields. Fields in tables cannot be specified.
Select a criteria from the options.
Enter the value to compare the field’s value. The parameter accepts the following inputs:
Use this parameter if you want to export the result of the calculation 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 that meet the criteria, the result will be zero. If there were no records as a result of the “Select Record Action”, the result will be zero.
You cannot select the action for “when there are no records that meet the conditions” such as “Calculate Average of Fields in Records by Providing Conditions.”