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

  • Bjksolutions
    Asked on 10. tammikuuta 2018 klo 11.15

    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.

  • David Jotform Support
    Replied on 10. tammikuuta 2018 klo 12.24

    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:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

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

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

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