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

    Can I have my form submissions posted into my online MSSQL Database?

    Asked by Jay Slazinski on November 06, 2013 at 01:16 PM

    I would like to have our membership application and the IRS w9 tax form that need to be filled out by my customers online.  They could fill them out, sign them, and the data would be saved to our online database.  A copy would then be emailed to them and to us for eletronic storage.

    The forms, are currently in PDF format on the bottom right of our website  www.minorleaguegolf.com

     

    Page URL:
    www.minorleaguegolf.com

    Submissions insert to database MSSQL
  • Profile Image
    JotForm Support

    Answered by ardy0689 on November 06, 2013 at 02:18 PM

    Thank you for taking an interest on JotForm and for posting your inquiry.

    Yes can create such forms here on JotForm. You have 2 options in order to achieve insertion to your MSSQL database.

    The below steps assumes that you have already created your membership and tax form on JotForm.

    Option 1: Enabling HTTP POST submission

    1. Navigate to "Setup and Embed" tab

    2. Click "Preferences button"

    3. Navigate to "Advanced Settings" Tab

    4. Find the section "Send Post Data" and set it to "Yes"

     

    5. Go to "Setup & Embed" tab again

    6. Click "Thank you" button and the Thank You Wizard should popup immediately.

    7.Choose "Custom Url" and click Next

     

    8.Set the receiving page of to be redirected to, after users submitted the form.

    As you can see here you will need to create an ASP page where it fetches the POST variables sent by JotForm.

     

    It is from this page that it will also inserts the acquired data to your MSSQL

    Example:
    <%

    Dim FirstName

    FirstName = Request.QueryString["firstname"]

    .
    .
    . 'some code here for MSSQL connection and MSSQL insertions for FirstName into your database

    %>

     

    Option 2: Using Webhooks.

    1. Navigate to "Setup & Embed"

    2. Click "WebHooks"

     

    3. You also going to need to create the receiving URL to fetch data. You do not need a Thank you redirect here. WebHooks work in the background silently prior to submission of the form

     

    Please read more on How to Setup Webhook with JotForm.

    Note:For ASP you need to devise a script inorder to get the HTTP Raw Request. This is a JSON format.

    If you require further assistance please do not hesitate to ask. If should in case you have a different unrelated inquiry please us this link to create a separate new thread https://www.jotform.com/answers/answer.php. Thank you

  • Profile Image

    Answered by fname  on January 06, 2016 at 06:57 PM

    does this work?

  • Profile Image
    JotForm Support

    Answered by mert on January 07, 2016 at 04:19 AM

    Yes, those methods are working and in addition to them, other methods have released in the course of time.

     

    1) On the following guide, the method about sending data of your submissions to your MySQL server with PHP is explained:

    http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

     

    2) From the following link, you can export MySQL output from your submissions' data:

    http://mysqldump.jotform.io/

     

    3) With Zapier, you can link your submissions to your MySQL server directly:

    https://zapier.com/zapbook/jotform/mysql/4061/add-jotform-submissions-to-mysql/

     

    I hope these ones will work for you. Please, let us know, if you need extra assistance.

     

    Thanks.