Job Runner

If All Field Satisfy Same Condition

Summary

The condition is whether the values of multiple fields meet the same specified criteria.

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 no records 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 All Field Satisfy Same Condition” or “If One or More Fields Do not Satisfy Condition.”

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
  • Group
  • Blank space

This parameter does not accept fields that are inside tables.

Criteria

You can select a condition as referring follows:

  • Refer to List of field criteria
  • Refer to [How Customine evaluates comparisons based on “equal” and “not equal”.
  • Refer to [How Customine evaluates comparisons based on “less than” and “greater than.”

Comparison value

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

  • Direct input
  • Formulas ([Learn How to Write Formulas)

Condition Inverter

Clicking the Condition Inverter will change the condition to “When at least one field does not meet the condition.”

Suppose at least one of the multiple fields does not meet the specified conditions. In that case, it will execute the action limited to that record when there is **at least one **among the selected records where **at least one **of the fields does **not **meet the specified conditions.