2 Replies Latest reply on Mar 13, 2014 11:47 AM by Jaryd

    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.

        • 1. Re: Distribute Form Results - Multiple Answers for 1 question
          Ratnesh Ranjan Level 4

          Hi Jaryd,

           

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

           

          Regards,

          Ratnesh

          1 person found this helpful
          • 2. Re: Distribute Form Results - Multiple Answers for 1 question
            Jaryd Level 1

            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.