Job Runner

If One Field Satisfy Condition

Summary

The condition is whether at least one value among multiple fields satisfies the specified condition.

How to Use

Check whether at least one record meets the conditions in all specified fields of the selected records. If there is more than one record that meets the conditions, the action will be executed limited to the records that meet the conditions. If there are no records that meet the conditions, no action will be taken.

The action that triggers this condition and the subsequent actions will only retrieve the rows constrained by this condition when obtaining the record with the specified action number in “Record”.

Parameter

Set Record, Field, Criteria, Comparison value.

Record

Select the action to retrieve records with fields you want to compare.

If there are no records, the action will not be executed regardless of whether the condition is inverted. In other words, if no records exist, the action will not be executed, either “If One Field Satisfy Condition” or “When All Multiple Fields Don’t the Criteria.”

Field

Select the fields that should be evaluated during the comparison.

You can select multiple fields.

Note that this parameter does not accept the following field types:

  • Attachment
  • Table
  • Related Records
  • Field group
  • Blank space

This parameter does not accept fields that are inside tables.

Criteria

You can select a condition as referring follows:

Comparison value

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

Condition Inverter

Clicking the Condition Inverter will change the condition to “If all multiple fields do not satisfy condition.”

Suppose if all multiple fields do not satisfy condition. In that case, it will execute the action limited to that record when there is at least one among the selected records where all fields do not meet the specified conditions.