I can't seem to figure out how to calculate if a value in one field is one of the values in a checkbox list. When I use Case (field1 = List ( field2 );"something happens"), "something happens" only when just one checkbox is checked. But I want this to be true when the same value is checked, no matter if there are others checked as well. Does this make sense? I hope someone can help me out...

VAB

Edited October 22, 200817 yr by Guest

PatternCount ( ¶ & YourCheckboxField & ¶, ¶ & YourField & ¶ )

If it is checked it will return a value, most likely 1 if its unique.

I can't seem to figure out how to compare the value in one field to one of the values in a checkbox list. When I use Case (field1 = List ( field2 );"something happens"), "something happens" only when just one checkbox is checked. But I want this to be true when the same value is checked, no matter if there are others checked as well. Does this make sense? I hope someone can help me out...

VAB

Please do not double post.

http://fmforums.com/forum/showtopic.php?tid/198847

Case(

Length ( FilterValues ( Field1 ; Field2 ) ) ; "something happens"

)

i'm sorry. tried to delete the other post, didn't work.

Topics Merged...

thanks!

thank you!!! I don't understand why, but it totally works!

Sorry, both solutions seemed to work, but in end they didn't give me the results I wanted. So let me tell a little bit more about what I want:

I use the calculation for a "replace field contents" behind a button.

Field1 = 1,2,3... or 14

Field2 (checkbox set) = 1,2,3... and/or 14

Field3 = empty or "x"

button1: Case1(When field1 = one of selected in field2 ; field3 = "x")

button2: Case2(When field1 = one of selected in field2 ; field3 = "")

Solution with length() doesn't works in case2. Solution with patterncount() doesn't work because it counts the "1" in "11", "12", "13" etc. as well.

Can you help me?

First why are you using Replace Field Contents?

Second why do you have two buttons? It seems as if you only really need 1.

The PatternCount should work but you can use FilterValues as well. I keep forgetting about that new function.

All you really need is one button with a SetField.

Set Field [ Field3; FilterValues ( Field2 ; Field1 )]

I'm guessing PatternCount failed because you didn't construct the formula with the pilcrows (carriage return characters) as John specified in his original post.

that's it! thank you.

My field3 is a selection box too, to select my records in my database.

I use two buttons, because I want to extend my previous selection. Anyway, it works now... thank you very much!