Distribute Form Results - Multiple Answers for 1 question

[Jaryd]

Hello All,

I am trying to just really optimize the Results of a distributed form.

So I have questions which have multiple correct answers.  A, B, C, D, E.

If the question is answered with A & B, I would like the results to be only 1 column and have 'A, B'  (no comma would be fine).

Can anyone help me accomplish this?

I am relatively new to Livecycle, but decent at computers in general.

[Ratnesh_Ranjan]

Hi Jaryd,

You can add a hidden field in the form and concatenate the value(answer) selected by the user.

Regards,

Ratnesh

[Jaryd]

THanks Ratnesh,

Let me go into some detail of how I got this to work if anyone comes across it in the future.

#1 In order to concatenate, you will need to enable the script editor in livecycle.  This is done by Window -> Script Editor (Cntrl+Shift+F5)

Make a new textbox and click on it.

In the Script Editor

Then for Language:  FormCalc

Show: Calculation.

Press the fn button and choose concat.  replace the s1,s2  with the name of the fields.  This should be easy if you are at all familiar with excel.

Next, on each box you dont want in the results, you must go to Object->Binding and change to "No Data Binding"

Finally, make the text box invisable.  I like to do this last after testing to make sure it works.