Customize

If All Selected Field Value is Equal to One of the Specified Values

Summary

Check whether all the selected values in the specified selection field match any multiple values.

How to use

In other words, “When the set of values selected in the field is A and the set of comparison values is B, A⊂B”.

For example, if the comparison values are three values X, Y, and Z, the condition judgment will be as follows:

  • Selection of fields X, Y ⇒ Meets the conditions
  • Selection of fields X, Y, Z ⇒ Meets the conditions
  • The selection of fields X, Y, Z, W ⇒ does not meet the conditions (because W is not in the comparison value)

If the field value is empty, the condition is considered satisfied regardless of the comparison value.

Parameters

Set Field and Comparison value.

Field

Select the field that should be evaluated.

This parameter accepts the following field types:

  • Check box
  • Multi-choice
  • User selection
  • Department selection
  • Group selection

If you want to select a field inside a table (column), you must configure the primary Condition or the Do so that Customine is able to identify the correct row.

Comparison value

Specify the values you want to compare, separated by commas.

Spaces before and after the value are ignored, and full-width and half-width, as well as uppercase and lowercase, are not distinguished.

To compare with the user selection field’s value, specify the login name; to compare with the department selection field’s value, select the department code; to compare with the group selection field’s value, specify the group code.

It is also possible to specify the values of Multi-choice or Check box fields using expressions. Please note that it will be the currently selected value, not all the options in the field. For example, in the case of the following expression, the condition is met if the value specified in the “Field” matches any of the values selected in the “multi_choice_1” field.

=multi-choice_1
Information for advanced users

When specifying using a formula, it is also possible to specify in array format.

= [notification-date_1, notification-date_2, end-date]

Condition Inverter

Clicking the Condition Inverter will change the condition to “If the value of the field is not equal to any of the specified values.”

Compatibility with krewSheet

This Condition is compatible with krewSheet.