AnsweredAssumed Answered

How to reference multiple checkboxes in the same field

Question asked by nacrom on Oct 24, 2018
Latest reply on Oct 25, 2018 by nacrom

Hello Everyone,

I am working on a project with a field called "Machinery" with the following items listed as individual checkboxes (Press, Color Copier, BW Copier, SS Copier, Xante, NO Printing Required).

 

i know how to reference the field if only 1 check box is selected in a Case Statement, I.E.:

Case(

fn_PRD_Machinery="Press"; "On Press";

fn_PRD_Machinery="Color Copier"; "On Copier";

fn_PRD_Machinery="BW Copier"=; "On BW Copier";)

 

but what i am having problems doing is being able to reference when multiple checkboxes are selected, for example if Press and Color Copier are both selected

Case(

fn_PRD_Machinery="Press" and fn_PRD_Machinery="Color Copier"; "Printing on Press & Color Copier";

)

 

Any help would be appreciated on how to reference both active checkboxes in a single case statement.

 

John

Outcomes