Can I populate form fields with data from my own database or csv/txt file?

  • Profile Image
    Dominique Sinclair 
    Asked on January 29, 2015 at 08:04 AM

    Hi

    I was wondering if there is a way to populate form fields from an external source. So for example, when a user enters their employee number their name and cost centre would be automatically populated.

     

    Thanks

  • Profile Image
    Welvin
    Answered on January 29, 2015 at 11:34 AM

    Hi Dominique,

    Unfortunately, we don't have a direct feature to accomplish this. A workaround would be to use our source codes method and manipulate the source codes to create a lookup function to your database similar to the one that is described here: http://stackoverflow.com/questions/558445/dynamically-fill-in-form-values-with-jquery?lq=1.

     

    Or, you can use our update to a field conditional logic: http://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Caculation-into-a-field-using-a-Condition. However, this method requires you to add a conditional logic for all the employee number. This means a manual configuration to the form.

    Thank you!

  • Profile Image
    Welvin
    Answered on January 29, 2015 at 11:51 AM

    By the way, I have forwarded this to our developers as a feature request. I'm not sure if this is possible, but if there are updates, you should know it via this thread.