JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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 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
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
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
does this work?
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:
2) From the following link, you can export MySQL output from your submissions' data:
3) With Zapier, you can link your submissions to your MySQL server directly:
I hope these ones will work for you. Please, let us know, if you need extra assistance.