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
Solved! Go to Solution.
this means you want to hide the control if both quality checks are successful?
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.
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!!
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"))