# Compare field with checkbox set

This topic is 5803 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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 by Guest
##### Share on other sites

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

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

##### Share on other sites

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

##### Share on other sites

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

##### Share on other sites

Case(

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

)

##### Share on other sites

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

Topics Merged...

thanks!

##### Share on other sites

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

##### Share on other sites

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?

##### Share on other sites

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 )]

##### Share on other sites

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.

##### Share on other sites

that's it! thank you.

##### Share on other sites

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!

##### Share on other sites

This topic is 5803 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account