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

    How can I connect excel database to jotform?

    Asked by burachok on October 27, 2016 at 06:57 AM

    I'm trying to built form with prefilled options pulling data from excel file:

    i want my users to find the price of the car depending on the year of the car model -> shows only certain make of the car -> shows only that year's models of the make of car selected

    at the end it shows the price of the selected year-make-model of the car they select.

    from there they continue filling the basic jotform and submit.

     

     

     

    JotForm excel how how can i
  • Profile Image

    Answered by Irshad on October 27, 2016 at 08:11 AM

    Unfortunately, there is no direct way to pre-populate  your form based on data from a database. Currently, you can pre-populate your form's fields with data manually before the form respondent can fill the form.

    You can use the Field Prepopulator App to do this.

    Or using the URL parameter method of the form. Check this user guide 

    -Prepopulating-fields-to-your-JotForm-via-URL-parameters

    You can also 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.

    If you have any query or need further assistance, feel free to revert back.

    Thank you.