Can I populate values to multiple fields based on the answer of a certain field?

  • asifjamilakhtar
    Asked on July 29, 2016 at 8:07 AM
    How do v populate multiple field based on 1 field. E. G i want to populate
    employee name, region and email address on the basis of employee number
  • John_Benson
    Replied on July 29, 2016 at 9:04 AM

    This is possible with the use of Update/Calculate Field condition. However, you will need to create a lot of conditions in order to do this. I created a demo form (https://form.jotform.com/62074327499969), please do check it.

    Here's a guide on how I did the demo form:

    1. Create 4 text boxes. The fields are for ID, Name, Age and Email.

    Can I populate values to multiple fields based on the answer of a certain field? Image 1 Screenshot 70

    2. Click the Conditions button in the Form Builder.

    Can I populate values to multiple fields based on the answer of a certain field? Image 2 Screenshot 81

    3. Select Update/Calculate Field condition.

    Can I populate values to multiple fields based on the answer of a certain field? Image 3 Screenshot 92

    4. The condition should go like this:

    If the value of ID is equal to "001" then "John Smith" will be entered in the Name field.

    Can I populate values to multiple fields based on the answer of a certain field? Image 4 Screenshot 103

    5. You need to create a condition for the other fields as well.

    If the value of ID is equal to "001" then "30" will be entered in the Age field.

    If the value of ID is equal to "001" then "johnsmith@companyemail.com" will be entered in the Email field.

    Can I populate values to multiple fields based on the answer of a certain field? Image 5 Screenshot 114

    6. Here's how it will look like:

    Can I populate values to multiple fields based on the answer of a certain field? Image 6 Screenshot 125

    You might want to check this guide: How-to-Populate-Field-with-a-Value-from-Another-Field

    Hope that helps. Thank you.

  • asifjamilakhtar
    Replied on July 29, 2016 at 9:45 AM
    Can multiple logics b implemented in 1 conition
    ...
  • John_Benson
    Replied on July 29, 2016 at 10:21 AM

    Unfortunately, it is not possible to have multiple "do / action" statement in the Update/Calculate Field condition. In the condition wizard, there is no "+" sign or no option to add another "do / action" statement. 

    Can I populate values to multiple fields based on the answer of a certain field? Image 1 Screenshot 20

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