Using API collect data from database and autofill the form

  • mandarpatil09
    Asked on June 24, 2014 at 8:43 AM

    Is it possible in API?

    to prepopulate with the data in it?

  • Ashwin JotForm Support
    Replied on June 24, 2014 at 9:37 AM

    Hello mandarpatil09,

    Unfortunately, there is no API to read data from your own database and then pre-populate your form fields.

    The only way I can currently think writing your own code to read data from your own database. If you have programming experience, here are the steps you should follow:

    1. Create a web page (PHP/ASP.Net).

    2. Write your own code to connect to your own database and fetch the data from the table.

    3. Read the values and then build a string using string builder class or similar.

    4. You need to basically create an URL parameters for your form to pre-populate field. The string which needs to be build is to concatenate the form fields and pass the database value in the corresponding form fields separating by "&" character. Ex: "fieldname=databaseValue&" and so on for all field.

    The following guide should help you get your form field's name:  http://www.jotform.com/help/146-How-to-find-Field-IDs-Names

    The following guide should help you understand the URL parameter features:  http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters

    5. Once you have built your URL parameters string, you need to concatenate your form URL and redirect to this string.

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!