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

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

    Asked by AL  on February 08, 2016 at 05:36 PM

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

    thanks

    sql sql server POST
  • Profile Image

    Answered by swalker286 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
    JotForm Support

    Answered by Charlie 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
    JotForm Support

    Answered by Charlie 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.