Customize

If All Table Columns Satisfy Same Condition

Summary

For all rows in a table, the condition is met if the field meets the specified criteria.

How to use

Parameters

Set Column Field, Criteria, and Comparison value.

Column Field

Select the field that should be evaluated during the comparison.

Only fields within the table can be selected.

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

  • Attachment

Criteria

You can select a condition from the following:

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 at least one row does not meet the condition.”

When this condition is used, the Action will occur if **at least **one row fails to meet the criteria specified in the “Criteria” and “Comparison value” parameters.

When there are no rows in the table

If there are no rows in the target table, the condition “If All Table Columns Satisfy Same Condition” will determine that the “condition is satisfied.” On the other hand, the condition “If at least one row does not meet the condition” indicates that the “condition is not satisfied.”

However, normally at least one row is reserved for editing, so unless rows are deleted through customization, there will be no state where there are no rows in the table.

Compatibility with krewSheet

This condition does not support krewSheet.