Prepopulate multiple fields via condition

  • QHuynh
    Asked on June 24, 2016 at 10:11 AM

    Sorry, I wasn't sure to post the question..

    Here's my question about Auto fill in Addresses..... if I created dropdown list of customer .. How can I do IF ... DO condition to fill in Address ... 

    Like this example :  http://form.jotform.us/form/51336670016146

    that's easy to fill in with only one field ... not like addresses have multiple field and I couldn't do the IF condition to auto fill in ... 

    ... example..   I'd like type in Lab Name:  Verch .. then it will fill in Address, Phone, Email ...

     

     

    This is my form:  https://www.jotform.com//?formID=60414937839162

     

     

    Thanks 

  • liyam
    Replied on June 24, 2016 at 11:30 AM

    Hello QHuynh,

    Thank you for posting your question. However, it is unclear what your concern is about with just the title of the question "address".  If you can provide us more information with regarding your concern, it would be great so we can assist you better.

    We'll be looking forward to your response.

    Thanks.

  • QHuynh
    Replied on June 24, 2016 at 11:49 AM

    Sorry, I wasn't sure to post the question..

    Here's my question about Auto fill in Addresses..... if I created dropdown list of customer .. How can I do IF ... DO condition to fill in Address ... 

    Like this example :  http://form.jotform.us/form/51336670016146

    that's easy to fill in with only one field ... not like addresses have multiple field and I couldn't do the IF condition to auto fill in ... 

    ... example..   I'd like type in Lab Name:  Verch .. then it will fill in Address, Phone, Email ...

     

     

    This is my form:  https://www.jotform.com//?formID=60414937839162

     

     

    Thanks 

  • Elton Support Team Lead
    Replied on June 24, 2016 at 12:53 PM

    Hi,

    If you want to fill multiple fields via condition base on a single IF rule, then you have to create multiple conditions for that.

    Here's an example:

    Prepopulate multiple fields via condition Image 1 Screenshot 20

    Please note that you have to define all the values into the conditions wizard. If you're looking for retrieving these values somewhere else (like from a database) and populate them into the fields, then that's not possible in the conditions wizard.

    Hope this information helps!

  • Q
    Replied on June 24, 2016 at 3:31 PM

    IS there any method retrieving values like from database and populate them in the fields? 

    I did try IF .... IS FILLED ..... INSERT 1231234567 INTO Phone Number ! IS NOT WORKING.

    Phone number had ID:area, and ID:phone ... is not populate in any of those fields. 

    Thanks for your support

  • Kevin Support Team Lead
    Replied on June 24, 2016 at 4:07 PM

    IS there any method retrieving values like from database and populate them in the fields? 

    Unfortunately, there is no a way to get data from a database and insert it into your form fields, to do this you will need to get the source code if pre-populate the fields via the URL, here is a guide about pre-populating fields: Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    But there is no an integration or app that will help you to get data from a database and insert it into forms. 

    Regarding to your second report about the condition and phone field, it has been moved to a different thread, it can be found here: https://www.jotform.com/answers/869037 

    This is to avoid confusion and assist you about different questions / issues in the same thread, we will assist you there as soon as possible. 

     

  • cliffstevenson
    Replied on August 13, 2016 at 5:10 PM

    Sorry,

    I need help in populating a Name fields which are divided to First Name and Last Name. Also doesn't work on Phone numbers.

    I can't fill it using the Update / Calculate Field in Conditions. It's only possible when it's a plain text box. Is there any other way?

    Thank you.
  • jonathan
    Replied on August 13, 2016 at 6:13 PM

    @ cliffstevenson

    We will resolve your concern here https://www.jotform.com/answers/905719