How do I use multiple fields to conditionally populate another field

  • jaysecreast
    Asked on June 16, 2016 at 9:41 PM

    I have a form that will be used for baseball registration, the user will enter the child's gender and date of birth. The form already calculates the child's age automatically.

    What I am trying to do is take a combination of the child's gender and their age to create an output field that will display the division they will be placed in.

    EX:

    if gender = male and age = 9 then output would = 9/10 baseball

    if gender = female and age = 12 then output would = 11/12 softball

     

    There will need to be many different outputs based on the gender and age, but was unsure how to accomplish this (I would normally say using a case statement, but didn't know if that was possible)

     

  • jonathan
    Replied on June 16, 2016 at 10:51 PM

    Please test my form https://form.jotform.com/61678860212963

    It work like this...

    How do I use multiple fields to conditionally populate another field Image 1 Screenshot 30

    The Conditions I created is like this

    How do I use multiple fields to conditionally populate another field Image 2 Screenshot 41

    As you can see, you can use Update/Calculate field values to achieve population of a field base on different/multiple fields value.

    You can clone the test form also so that you can review it on your Form Builder.

    User guide: https://www.jotform.com/help/42-How-to-clone-an-existing-form-from-a-URL

    Let us know if you need further help.