Job Runner

If Field Value is Empty

Summary

The condition is whether the values of the specified fields are empty.

How to Use

Check whether one or more records have empty field values in the specified records. If more than one record has empty field values, the action will be executed only on 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 the field value is empty” or “If the field value is not empty.”

Field

Select the fields that should be evaluated during the comparison.

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

Reversing this condition changes it to “If the field value is not empty”.

Suppose if the field value is not empty. In that case, if there are one or more records that is not empty, the action will be 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.”