Job Runner

If At Least One Field Is Empty

Summary

The condition is whether at least one field among multiple fields has an empty.

How to Use

Check whether one or more records have empty values in the specified fields in the selected records. If there is more than one line 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 with this condition set and subsequent actions will only retrieve the rows limited by this condition when retrieving the record with the action number specified in “Record”.

Parameter

Set Record and Field.

Record

Select the action to retrieve records with the 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 at least one field is empty” or “If all multiple fields are not empty.”

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
  • Record number
  • Created by
  • Created datetime
  • Updated by
  • Updated datetime
  • Status
  • Assignee
  • Table
  • Related records
  • Field group
  • Blank space

This parameter does not accept fields that are inside tables.

Condition Inverter

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

Suppose if the field value is not empty. In that case, if one or more records have non-empty values in all fields, the action is executed only for those records.

Precautions

  • In this condition, whitespace characters and line breaks are ignored. If the field value is only whitespace or line breaks, it is considered to be “empty.”