Job Runner

Count the Number of Records by Providing Conditions

Overview

Count the number of records that meet the specified criteria in the retrieved records.

The calculated result can be used in another action.

Usage

Parameters

Set the Record, Condition Decision Field, Criteria and Comparison Value.

Record

Select the Action from the list of Actions that retrieved the records to be calculated.

Condition Decision Field

From the fields in the app, select the field you want to use to determine the condition.

The following fields cannot be selected.

  • Attachment
  • Table
  • Related records
  • Filed group
  • Blank space

You cannot include fields that are within a table.

Criteria

Choose a comparison method such as “equal to” or “greater than”.

Comparison Value

Comparison Value sets the value to compare with the field value. The comparison value can be one of the following values:

Precautions

  • If there are no records, the result will be zero. It will not be empty.

関連記事