Hi all,
Hoping someone can help as I am clearly getting my rule wrong. I have a control that I want to unhide if either part of a quality check fails (or both), after much research i came up with an or cluster:
or(not(contains(ProcessScore, "Fail")),not(contains(ServiceScore, "Fail")))
Unfortunately this only unhides the control when both fields fail, which is fine but I also need it to appear if one is set to Pass and the other Fail.
Any ideas? Many tha
Best answer by Tarf
View original
+8
Hi @kindrex,
this means you want to hide the control if both quality checks are successful?
Something like
not(contains(ProcessScore, "Fail")) && not(contains(ServiceScore, "Fail"))should do the trick. If both ProcessScore and ServiceScore do not contain "Fail" hide the control, otherwise show it.
Hi @Tarf
That worked perfectly for unhiding the control! The final step would be for me to add a validation rule, which I have done something similar when only referring to one control but as this is referring too two its being awkward
isNullOrEmpty(Remediation) && ProcessScore == "Fail" && ServiceScore == "Fail"
Any ideas? And thank you again!!
+8
Hi @kindrex
your rule would only be applied if both Score fields contain "Fail".
I think this could work:
isNullOrEmpty(my-control) && (contains(ProcessScore, "Fail") || contains(ServiceScore, "Fail"))
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.