I want to pull in fields from my own SQL Server DB - can I do that?

  • Profile Image
    AL 
    Asked on February 08, 2016 at 05:36 PM

    Can I pull in fields from my own DB and post back the results?

    thanks

  • Profile Image
    swalker286
    Answered on February 08, 2016 at 06:04 PM

    I also would like to know about this as a future option.  Commenting to follow responses.

  • Profile Image
    Charlie
    Answered on February 09, 2016 at 01:24 AM

    Not sure if I understand that correctly. Would you like to fetch or pull data from your own SQL server database, then submit it directly on your form? 

    Here's how I can see this possible:

    Method 1:

    1. Get or user your form's full source code. Here's a guide that you can follow: http://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form 

    2. Create a script that will fetch data from your own database and populate them in the form's input fields.

    3. Click the submit button, the data will then be sent to our servers.

     

    Method 2:

    You can prepopulate the form fields using the URL parameters. Here's a guide that you can follow: http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters 

    You can prepopulate it by fetching the data in your own database and redirect the user to a prepopulated form URL.

     

    I'm not sure if I understand your process flow correctly, if you can share us more information on this, please do let us know. 

  • Profile Image
    Charlie
    Answered on February 09, 2016 at 01:27 AM

    @swalker286

    To assist you and better discuss your concern, please do open a new thread by using this link: http://www.jotform.com/contact/. Thank you for your understanding.