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

    collect data from my Database and auto fill form fields

    Asked by thyrocare on June 24, 2014 at 03:10 AM

    I want to collect the data from my database is it possible to do that? like automatically fills the name who is using and cant able to edit.

    import data database prepopulate populator
  • Profile Image
    JotForm Support

    Answered by jonathan on June 24, 2014 at 04:57 AM

    Hi,

    Unfortunately there is no direct method to import data from databases and pre-populate the form fields.

    BUT what you can do instead is Import Data into your form's submission data using the Import Data App 

    You may need to export first your database data to a flat file like CSV so that you can use the flat file to import the data into JotForm submission data.

    --

    Currently, you can also 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

     

    Hope this help. Inform us if you need further assistance.

    Thanks!

     

     

  • Profile Image

    Answered by mandarpatil09 on June 24, 2014 at 05:15 AM

    Can i able to add my code in the form?

    so that i can use it on my website and i can link it

  • Profile Image
    JotForm Support

    Answered by jonathan on June 24, 2014 at 05:38 AM

    I am not quite sure how you meant on your latest message, but you can use the form's full source code embed on your website also (in case this was what you were looking for)

    User Guide: -How-to-get-the-Full-Source-Code-of-your-Form

    Actually, if you have programming skill or resource you can also create your own custom program using server side code like PHP to automate the pre-population of the form fields coming from the database.

    You can make use of the form's full source code to inject your own custom code to add functionality to the form.

     

    Thanks.

  • Profile Image

    Answered by mandarpatil09 on June 24, 2014 at 06:08 AM

    Is it possible in API?

    to prepopulate with the data in it?

  • Profile Image
    JotForm Support

    Answered by jonathan on June 24, 2014 at 08:44 AM

    I have created a new separate post for the new question here

    http://www.jotform.com/answers/395327

    We will respond to you on the new post.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by Welvin on June 24, 2014 at 08:46 AM

    I'm not sure if you can pull data from your database and put it as an options to your form using our API, but I am sure that is possible using PHP programming. Unfortunately, I couldn't make an example for you. 

    For now, you may consider using our Auto Complete widget: http://widgets.jotform.com/widget/autocomp. You can manually add the list to the settings, submitters shouldn't be able to edit the names.

    Thanks