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 need help creating forms using SQl/ Microsoft Access for school

    Asked by Danny  on November 12, 2014 at 09:26 PM

    I need to create 5 forms using the database that I've created in SQL, but I am not sure where to begin. Help would be greatly appreciated!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 12, 2014 at 11:16 PM

    Hello Danny,

    If I understand your question correctly, you want to create a form and then send the submission data to your MS SQL server DB. Is that correct?

    Please be noted that there is no built in feature to send the submission data to external source but with a little workaround, it is possible to achieve your requirement. Here are the options available:

    1. You can post the form's submission data to your own page by enabling the "Send Post Data" in your form preferences. Once the form is submitted, you can redirect to your thank you page where you can read the submission data and then save it to you MS SQL server DB. The following guide should help you:  http://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page 

    2. You can take advantage of our Zapier integration app as well. Take a look at here: http://apps.jotform.com/app/zapier_integration  You may also like to check this which should help you: https://zapier.com/zapbook/jotform/sql-server/7564/save-jotform-submissions-to-sql-server/ 

    3. You can directly download the SQL file of your submissions and import them in your database: Make a search by clicking on the following URL to find available apps for your database type:  http://apps.jotform.com/search/export 

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!