InfoPath Dev

I have a group of check boxes that are each separate elements on my form. I have a hidden field that feeds my database with the result of all checked boxes via the concatenation function. My problem is that the concatenation function returns blank spaces in the result whenever one or more of the check boxes is blank. How do I get the function to ignore unchecked boxes and just return a concatenation of all the checked fields?

 Thanks.

Heath

Are you using the default of the hidden field to concatenate your check boxes?  You could use the rules of each check box with a condition of is not blank.

Cheers,

Ren

I'm not sure I'm clear on what you are saying. Could you elaborate?

 Thanks.

Heath

Could this be resolved using filters on the hidden field that concatenates the check boxes? 

Hi

What I think RLPope was suggesting was to set a number of rules on the hidden field that are conditional by the check boxes not being blank.  For example,

Rule 1 Check-Box(CB) A is not blank and CB B is not blank and CB C is not blank and CB D is not blank Action Set a field's value, hidden field, concat(CBA, CBB, CBC, CBD)

Rule 2 CB A is blank and CB B is not blank and CB C is not blank and CB D is not blank Action Set a field's value, hidden field, concat(CBB, CBC, CBD)

And so on, this would then guarantee only the right rule will run which in turn guarantees the correct result.

Cheers

Adam