I have a multi-select field called Funding Sources which has the choices:
(Note: there are much more choices than this.)
Valid selections are:
1. Not Required is only selected
2. Any combination of all the choices EXCEPT Not Required
I know I could check for every combination with something like:
but there must be a more graceful way.
Thanks for your help.
Solved! Go to Solution.
@cmykkid .....There is a much simpler way to do that, below are the steps:
Excellent Kunal. Nicely written. Thanks.
But I believe there's a typo in step 3. The Choice control needs to be targeted. It should be:
If(greaterThan(count(ctrl_ch_Funding_Sources),1), If(inArray(ctrl_ch_Funding_Sources, "Not Required"), "invalid", "valid"), "valid")"
Regardless, much simpler and works like a charm.