What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Prepopulate multiple fields via condition

    Asked by QHuynh 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 

  • Profile Image
    JotForm Support

    Answered by liyam 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.

  • Profile Image

    Answered by QHuynh 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 

  • Profile Image
    JotForm Support

    Answered by EltonCris 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:

    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!

  • Profile Image

    Answered by on June 24, 2016 at 03: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

  • Profile Image
    JotForm Support

    Answered by Kevin_G on June 24, 2016 at 04: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. 

     

  • Profile Image

    Answered by cliffstevenson on August 13, 2016 at 05: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.
  • Profile Image
    JotForm Support

    Answered by jonathan on August 13, 2016 at 06:13 PM

    @ cliffstevenson

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