How can I fetch the value selected in a scale rating rather than the text answer?

  • Profile Image
    cf013
    Asked on November 01, 2018 at 11:04 AM

    How do I have a number value passed or entered on the submission form instead of the text answer?  For example:

    0 = no opinion
    1 = not welcomed
    2 = somewhat welcomed
    3 = welcomed
    4 = very welcomed

    We want the number value on the submission forms to analyze that data.

  • Profile Image
    Jim_R
    Answered on November 01, 2018 at 12:48 PM

    Your screenshot shows you're using the SCALE RATING field. However, it looks like you already figured out a better way to approach this using the SINGLE CHOICE field, assigned CALCULATION VALUES and CONDITIONS.

    In case we're mistaken and you still need help, don't hesitate to let us know.

  • Profile Image
    cf013
    Answered on November 01, 2018 at 01:43 PM
    Yes, I did. Thank you. Along the same lines I am trying to assign values to a multiple choice question but it keeps putting the value in the same results field. Does that make sense? Do you have any suggestions on how to handle this?
    Thank you,
    Chris Friedrich
    Note: This e-mail and any attachments may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of this e-mail and any attachments is strictly prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and deleting it from your computer system. Thank you for your cooperation.
    ...
  • Profile Image
    John_Benson
    Answered on November 01, 2018 at 03:12 PM

    Please check my demo form: https://form.jotform.com/83045483353962

    Is that what you're trying to achieve?

    If yes, you can clone my form to check the condition settings by following this guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    To insert text to a field based on the user's answer, please follow this guide: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    Let us know if you have any questions. Thank you.

  • Profile Image
    cf013
    Answered on November 01, 2018 at 03:22 PM

    Thanks John_Benson - I figured out what I needed. 

    Now I am working on a multiple choice selection where each choice number value needs to go in a different column.

    1541099964multiple choice.PNG

    No Children Attending = 0

    Tea Sprouts Preschool = 1   

    Frontier Elementary = 2       and so on....


    so it ends up like this:

    1541100140multiple choice value.PNG

  • Profile Image
    Jim_R
    Answered on November 01, 2018 at 04:06 PM

    I moved your last question to a separate thread to avoid confusion:

    https://www.jotform.com/answers/1630245

    I'll reply to you there shortly.