Is it possible to populate fields using an Excel Spreadsheet?

  • Profile Image
    chrisjsills
    Asked on June 18, 2015 at 07:32 PM

    Hi Guys,

     

    I'd like to create a form with a populated drop down list of account numbers, and based on what account number is selected from drop down list have corresponding fields populate with data from either an excell spreadsheet, google sheets or some other solution you could recommend.

    Any assistance is much appreciated.

    Regards,

    Chris Sills

    chris.sills@msecorp.net

     

  • Profile Image
    raul
    Answered on June 18, 2015 at 08:39 PM

    Unfortunately, we don't have such feature.

    You can prepopulate the fields in your form using URL parameters as described here: http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters, but you would need to create an external script in order to create the appropriate URL.

    So, for example, you could create a form with the dropdown you want to use, submit it and capture the selected value using POST or web hooks then you can use a custom script to do the searching on the spreadsheet, database, etc based on the selected option and redirect your users to a second form with the URL parameters for the prepopulated fields.

    I hope this makes sense.
    If you've further questions, please let us know.