Auto populating fields based on a drop down

  • Profile Image
    James 
    Asked 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
    ashwin_d
    Answered 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!