Hi, the way I understand it is there is now way to have the value of a field that is a check box set be Boolean because it will result in a multi-key. This will be a field where all values checked are the value. Look at the file I made to see. This is a good question and now you have made me curious. I think when the moderator (he will clear this right up, he is a Master) or another more experienced member than me get this they can shed some more light on it. Look at the file I put together and it is easy to have a result field that displays “Yes” if a value is checked. I used PatternCount but I am sure there are many ways to do so. In both I made 2 the value that if checked results in “Yes” in the Users::Result field. The Users::Type field that is not set to the check box set is the result of checked value.
If the check boxes are named: One, Two, Three, Four. And Two and Three are selected, the field will equal:
In whatever order they were selected.
So you could use the PatternCount function to see if your required term exists in the field, and therefore, if it is selected.
PatternCount ( Table::YourCheckBoxField ; "YourValue" )
PatternCount doesn't always work correctly for this purpose. Imagine the issues if your values were: Apple ; Applesauce ; Apple Dumplings and you need to check if Apple is selected.
a better option is to use:
Not IsEmpty ( FilterValues ( CheckBoxField ; SingleValue ) )
If the SingleValue has been selected in CheckBoxField, the expression returns true.
Bless you Phil. Really appreciate you.