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

    Auto populating fields based on a drop down

    Asked by James  on August 29, 2014 at 02:45 AM

    Hi,

    is it possible to link a form with a csv file that contains pre-population data? So have a drop down on the form that correlates to a row in the csv and when selected the relevant data is populated from the cvs into the form?

    for example, have a drop down that is

    house 1

    house 2

    then have fields for a postal address

    When the use select a house, this links with the csv and populates the address fields with the corresponding data in he csv. 

    i have MANY rows of data so I couldn't use the manual feature of having an IF statement for every selection option. 

    Thanks!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 29, 2014 at 05:07 AM

    Hello James,

    Unfortunately it is not possible to populate your form fields dynamically from any external data source. In another words, your form cannot read data from any external source.

    The only possibility available for your requirement is to add conditions to show hide form fields for every drop down. You can also update a form field value based on any condition. The following guide should help you:  http://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Caculation-into-a-field-using-a-Condition 

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!