Customize

Count the Number of Records

Summary

Count the number of retrieved records. You can reuse the result of the calculation in other Actions.

How to use

Parameters

Set Select Record Action and Target Field (Optional).

Select Record Action

Open the list of Actions and select the Action you used to obtain the target records.

Target Field (Optional)

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.

  • Text
  • Number
  • Text area
  • Rich text

Precautions

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 that meet the conditions” such as “Calculate Average of Fields in Records by Providing Conditions.”