Record Select Formula Help

[lesleycampbell]

I am using CR11. I am trying to do a record select formula that will look at multiple options for a field. The field gives the user the option of checking more than one box. I am trying to pull records for which certain options are selected even if more than one is chosen. Currently, my formula is only pulling records that have one box checked.

Field: Service_Area
Options (user can select multiple):
Box 1 - AL
Box 2 - GA
Box 3 - ZZZ
Box 4 - YYY
Box 5 - XXX
Box 6 - NC
Box 7 - SC
Box 8 - UDB

My current formula is {EmployeeMaster.Service_Area} like ['AL', 'GA', 'NC', 'SC', 'UDB']
The way it is, it only pulls records that just has 'AL' checked or 'GA' checked. If both 'AL' and 'UDB' are both checked, it will not pull the record.

Help?

 

[kray4660]

Try {EmployeeMaster.Service_Area} in ['AL', 'GA', 'NC', 'SC', 'UDB']

 

[lesleycampbell]

It is still excluding any that have those but also have additional options checked.

 

[kray4660]

Don't know. Seems like something odd is going on.

FYI: I do not really understand the Options (i.e., how do the boxes come into play). There is no indication of filtering on a prompt.

 

[lesleycampbell]

I adjusted the formula to include all possibilities. It is working now. Thank you for the help!