collect data from my Database and auto fill form fields

  • thyrocare
    Asked on June 24, 2014 at 3: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.

  • jonathan
    Replied on June 24, 2014 at 4: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!

     

     

  • mandarpatil09
    Replied on June 24, 2014 at 5: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

  • jonathan
    Replied on June 24, 2014 at 5: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.

  • mandarpatil09
    Replied on June 24, 2014 at 6:08 AM

    Is it possible in API?

    to prepopulate with the data in it?

  • jonathan
    Replied on June 24, 2014 at 8: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.

  • Welvin Support Team Lead
    Replied on June 24, 2014 at 8: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