AnsweredAssumed Answered

Check box OR search

Question asked by Nautilus_1 on Feb 12, 2018
Latest reply on Feb 18, 2018 by bigtom

I have a checkbox field in a table. The field has categories eg red, blue, big, small, heavy.... etc.

 

When multiple check boxes are selected in a SEARCH on a layout, records are returned which are the AND (intersection of the records). I need to find any record, which has the category field selected, that is the OR (Union) of records.


eg if big and heavy are checked I want all records with big and all records with heavy and all records with big and heavy.

I tried to write a script but see no way to implement it.

Outcomes