Customize

Count the Number of Rows in Table by Providing Conditions

Summary

Count the number of rows matching the specified conditions in the specified table.
You can reuse the result of the calculation in other Actions.

How to use

Parameters

Set Field for Judgement, Criteria, Comparison value, and Target Field (Optional).

Field for Judgement

Select the fields to be used for condition evaluation from the fields in the table.

Criteria

Select a criteria from the options.

Comparison value

Enter the value to compare the field’s value.
The parameter accepts the following inputs:

  • Direct input
  • Formulas (for details, refer to How to Write Formulas)
    • However, you cannot reference fields in the table from this expression.

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 table rows that meet the criteria, the result will be zero. Also, if there are no rows in the table, the result will be zero.

You cannot select the action for “when there are no rows that meet the conditions” such as “Calculate Average of Fields in Records by Providing Conditions.”