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

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

    Asked by Dominique Sinclair  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

    CSV OR source name
  • Profile Image
    JotForm Support

    Answered by Welvin 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
    JotForm Support

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