Need to assign Numeric code to the questions while generating the report for the questions displayed in front end

  • Profile Image
    Asked on January 10, 2018 at 11:15 AM

    I have created one form and now what i want is that when we export the submissions the questions added and the response captured in the form should be displayed in numeric code. Please help me in assigning the codes in questions and the responses captured. 

    For eg.  In a form a question is being displayed like " Are you a homeowner" and the response to this question are 'Yes', 'No'.  So what i want is that when i export the report i need to assign the code for this question like " Are you a homeowner" code is 555 and the response code is 1 for yes and 2 for No. 

    Is it possible to do in this format. If yes please guide me with the steps in order to achieve success in this.

  • Profile Image
    Answered on January 10, 2018 at 12:24 PM

    The only way I can see to do this would be to have a separate set of fields for the codes.  One field with the default value to represent the field question value and one field to update with the answer value.  You can assign calculation values to question options:

    Then use a calculation field to display the value of the chosen option:

    The fields used to show the numerical values could be hidden.