If field contains specific value, do not allow next step in workflow

[Scott McDonald]

Hello -

I feel like this can be handled via Validation rule, however I'm just not getting the results I need. I have a field NNN (dropdown) with multiple fields (Yes, Testing, No, QA Complete). I want to display a warning message if the values Yes or Testing are present on ticket, which in essence won't allow them to advance to the next step in the workflow.

Thank you, Scott

[Fidel Castro Armario]

HI Scott,

You can do it using the "Boolean validator with math, date-time or text-string terms" with the following boolean expression:

"Yes" in %{nnnnn] OR "Testing" in %{nnnnn]

where nnnnn is field code for the Multi-Select custom field.

[Scott McDonald]

That worked! If I have 3 separate Multi-Select custom field with each one having the same values of Yes, Testing etc, is there a way to say "if any of those mult-select have the value of yes or testing selected, please fix the error before you move onto the next workflow step"?

[Fidel Castro Armario]

You should use the following boolean expression:

"Yes" in %{aaaaa} OR "Testing" in %{aaaaa} OR
"Yes" in %{bbbbb} OR "Testing" in %{bbbbb} OR
"Yes" in %{ccccc} OR "Testing" in %{ccccc}

where aaaaa, bbbbb and ccccc are field codes of the 3 Multi-Select custom fields.

[Scott McDonald]

Here's what I've added and the validation is not working how I want it to work. If I have flip the value to Yes in 14210 and leave 14211 and 14212 in QA Accepted, it allows the ticket to go through.

"Yes" in %{14210} OR "Testing" in %{14210} OR "None" in %{14210} OR "Yes" in %{14211} OR "Testing" in %{14211} OR "None" in %{14211} OR "Yes" in %{14212} OR "Testing" in %{14211} OR "None" in %{14212}

[Fidel Castro Armario]

Sorry, I misunderstood your requirements. Try this boolean expression:

"Yes" not in %{aaaaa} AND "Testing" not in %{aaaaa} AND
"Yes" not in %{bbbbb} AND "Testing" not in %{bbbbb} AND
"Yes" not in %{ccccc} AND "Testing" not in %{ccccc}

[Scott McDonald]

Fantastic! One last question - if the user doesn't select a value in one of the 3 multi-select fields, is there a way to account for that and have the error message appears if a no value is selected?

[Fidel Castro Armario]

Use another "Boolean validator with math, date-time or text-string terms" validation in the same transition with the following boolean expression:

%{aaaaa} != null AND %{bbbbb} != null AND %{ccccc} != null

[Scott McDonald]

That did the trick - thank you much!

[Fidel Castro Armario]

You are welcome :)