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

    Is it possible to populate a field from a database or excel file?

    Asked by jplatts on June 28, 2016 at 09:26 AM

    i am using a jotform for a service ticket in the field.  it would be nice if our technicians filling out the form could choose from a list of customers already pre-populated in a database or excel file.  is that possible?

    pre-populated excel file
  • Profile Image
    JotForm Support

    Answered by Welvin on June 28, 2016 at 10:01 AM

    Unfortunately, we don't have a feature that would allow you prepopulate a field from a database. You can hire a developer to integrate the database to your form. You can use the source codes embed to do that: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    Another workaround would be to manually update the list in the form. You can use the dropdown field. You can also use our autocomplete widget: https://widgets.jotform.com/widget/autocomp