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

  • Profile Image
    Jay Slazinski
    Asked on November 06, 2013 at 01:16 PM

    I would like to have our membership application form 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

     

  • Profile Image
    ardy0689
    Answered 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
    fname 
    Answered on January 06, 2016 at 06:57 PM

    does this work?

  • Profile Image
    mert
    Answered 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.