AnsweredAssumed Answered

Can I run a "Find" using "Checkbox set" criteria as an "OR" statement?

Question asked by ErickJ.Gonzalez on Jan 27, 2016
Latest reply on Jan 27, 2016 by Mike_Mitchell

I have a DB for community resources where agencies/programs are categorized by service type.  I have a “Service Type” field as a  “Checkbox Set” with the following options:

Health                 Transportation              Heating Assist.

Advocacy            Academic                      Career Develop.

Legal                   Mental Health

 

(Some agencies/programs offer services in more than one category)

 

Is there a way that I could run a “Find” using a “Checkbox set” as an “OR” statement? In other words is there a way I can run a “Find”, select more than one box in the "checkbox set" and have the “Find” return all the agencies/programs that have any of the selected boxes?

 

i.e. "FIND" any agencies/programs that have/offer these services:

x Health                 x Transportation              Heating Assist.

Advocacy            Academic                      Career Develop.

Legal                   x Mental Health

 

(If I do this now, I get all agencies/programs that have/offer all three selections.)

 

Is it possible? If so, what’s the best way?


I know I can run a “Find” and select x Health,

click “New Request” then x Transportation,

click “New Request” then x Mental Health, and

then “Perform Find” which will return all the entries/records that have any of those options selected.

Outcomes