Customize

If Field Value is Equal to One of the Specified Values

Summary

The condition checks if the value of the specified field matches any of the multiple given values.

How to use

Parameters

Set Field and Comparison value.

Field

Select the field that should be evaluated.

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

  • Check box
  • Multi-choice
  • Attachment
  • User selection
  • Department selection
  • Group selection
  • Table
  • Related records
  • Field group
  • Blank space

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.

The comparison of whether it matches is the same judgment method as the “equal” condition of “If the field value is a specific value”. Spaces before and after the value are ignored, and full-width and half-width, as well as uppercase and lowercase, are not distinguished.

For example,

If specified Fuchu,Nakayama,Kyoto,Hanshin,

the condition is met if the field value is either “Fuchu”, “Nakayama”, “Kyoto”, or “Hanshin”.

If you want to include an empty value in the comparison value, you can create an item after the comma without specifying anything, as shown below: In the following example, the condition is met when the field value is “None” or empty.

None,

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.