Hi all,
Is it posible to clear all selected values in an EnumList when a value None of the above is selected. The EnumList is of Stack input mode.
You can do it with an Action on the form save event.
so depending on the functional reasons you want to do that you can also use a valid if with
IF(IN(โNone of the aboveโ,[Column]), COUNT([Column])=1,true)
this would insure that the user only selected none of the above in the drop down if they selected none of the above. Lucindaโs method will make sure that none of the other values are selected in the final result regardless of what they actually select if they do select โnone of the aboveโ
Another possibility is making a show column that says โleave blank if none of the above applyโ
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |