Controls

Re: Concatenation question

adamrharding — Fri, 05 Oct 2007 06:53:40 GMT

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

Re: Concatenation question

heath3106 — Fri, 28 Sep 2007 14:43:54 GMT

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

Re: Concatenation question

heath3106 — Thu, 27 Sep 2007 14:37:21 GMT

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

Thanks.

Heath

Re: Concatenation question

RLPopeIII — Thu, 27 Sep 2007 13:25:11 GMT

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

Concatenation question

heath3106 — Thu, 27 Sep 2007 12:25:51 GMT

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