Aggregate or merge multiple field into one field

[Bob Zmuda]

I have a form with multiple checkboxes set to text values, e.g., (1) checked
is Bob, unchecked is Alice, (2) checked is Andy, unchecked is Sara, and so
on. I want to aggregate or merge the values of these checkboxes into one
field or textbox, giving me a final value of "Bob, Andy," etc. How can I do
this? Thank you.

 

[steve]

I have a form with multiple checkboxes set to text values, e.g., (1) checked
is Bob, unchecked is Alice, (2) checked is Andy, unchecked is Sara, and so
on. I want to aggregate or merge the values of these checkboxes into one
field or textbox, giving me a final value of "Bob, Andy," etc. How can I do
this? Thank you.

Add a text box to the field
Add a hidden text box to you form with a value of ","

Double click the field

Under Default Value
Click Fx
Click Insert Function
Choose Text, then Concat
Double Click where it says "Double Click etc"
Point to the appropriate fields

Make sure you check the box that reads "Update this value when the
results of the formula is recalculated....

should work....

steve

 

[Bob Zmuda]

Steve,

Thanks for the help. Your method works except for one thing - I only want
the comma(s) to appear if there is another value after it. For example, if I
have only 3 values, I should have only 2 commas (Alice, Bob, Charlie). If I
have 5 values, I should have only 4 commas (Alice, Bob, Charlie, Danielle,
Eric). Can this be done?

 

[steve]

Steve,

Thanks for the help. Your method works except for one thing - I only want
the comma(s) to appear if there is another value after it. For example, if I
have only 3 values, I should have only 2 commas (Alice, Bob, Charlie). If I
have 5 values, I should have only 4 commas (Alice, Bob, Charlie, Danielle,
Eric). Can this be done?










- Show quoted text -

that was close.....

i fooled around with rules but i couldn't find a way to do it. there
very well could be a way,
but i couldn't find it quickly.

if it were my project, i would write some code to do it - should be
pretty simple. unfortunately,
i can only help if you code using VB.NET (managed code, using Visual
Studio). maybe somebody else can chime in
to help with script..

steve lescure