If [ ( ValueCount ( FilterValues ( Table::CheckboxSet "Box A¶Box B¶Box C") ) = 3... etc.
Because "BoxA" & "Box B" & "Box C" = "BoxABox BBox C", and even if you inserted the return characters, the values in CheckBoxSet are in the order the user clicked them, not the order of your value list.
Instead, use FilterValues to determine what values in your test set are in the CheckBoxSet, and see if all three are there.
Does this make sense to you? Will it work for you?
Hello, William. There's a basic behavior in checkbox sets that will affect your outcome, and is likely what's causing the malfunction. Checkbox sets are stored in FileMaker as return delimited lists. For example, if you choose Box A and Box B, the result will look like this:
Additionally, the values appear in the order the user selected them, so if he chose Box A, then Box C, then Box B, you'd get:
So, in order to determine if your desired pattern is present, you can't use Box A & Box B & Box C for both reasons: First, the values are in a list, not a string, so your "=" won't match, and second, they could appear in any order.
What to do? Use the FilterValues function to determine if your values are present. For example:
If [ ValueCount ( FilterValues ( Table::CheckboxSet ; "Box A¶Box B¶Box C )) = 3 ]
// All three values selected
The various Value functions (GetValue, LeftValues, MiddleValues, RightValues, FilterValues) are invaluable to learn.
Darn that refresh ...
We should've picked shifts today.
Thank you Chris & Mike! I revised my script as you suggested and it worked exactly how I expected.