The condition is whether the specified field’s value matches any of the multiple values.
Check whether at least one record meets the conditions in all specified 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”.
Set Record, Field, and Comparison value.
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 field value is equal to one of the specified values” or “If field value is not equal to any of the specified values.”
Select the field that should be evaluated.
Note that this parameter does not accept the following field types:
This parameter does not accept fields that are inside tables.
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
When specifying using a formula, it is also possible to specify in array format.
= [notification-date_1, notification-date_2, end-date]
Clicking the Condition Inverter will change the condition to “If the value of the field is not equal to any of the specified values.”
Suppose if the value of the field is not equal to any of the specified values. In that case, it will execute the action limited to that record where the field does not match any of the specified values.