Job Runner

If All Fields Are Empty

Summary

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

How to Use

Check whether there are one or more records with empty values in all specified fields in 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 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 all fields are empty” or “If one or more 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 at least one field is not empty.”

Suppose at least one field is not empty. 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 is **not **empty.

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.”