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

    How get form data after submit to MS SQL server?

    Asked by pavelgon on April 11, 2017 at 10:23 AM

    Hello,
    I have an integrated form to the my website page. And I want to save submitted form data in my database  (MS SQL Server). The new JotformFeedback() is used for form initialization.

    I discover a few variants of how to implement this:
    1) Retrieve form data by using some callback function, that will contain all necessary data.
    2) Get the notification to URL, that the new submission is created with ID of this submission.  Then I will be able to use your API to retrieve submitted form data 

    Do I have the possibility to use one of those variants? If yes, could you please help me to find necessary documentation?

    Thanks in advance

  • Profile Image
    JotForm Support

    Answered by Kiran on April 11, 2017 at 12:43 PM

    We have a guide that helps in sending the submissions to MySQL database using PHP.

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

    Since you want to connect to the MSSQL database, you may be using ASP to send the data. The process is the same that might help with the above guide.

    You may enable the POST Data from the form settings so that the form submitted data can be sent to an external data source using POST method.

    You may create a new file that connects to your MSSQL database and process the POST data to the database. 

    Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help. 

  • Profile Image

    Answered by pavelgon on April 12, 2017 at 03:45 AM
    Thank you very much for your response. This seems like what I need.
    Tell me please if I  have stopped on the item "Set Yes on Send Post Data". I chose "Yes". And I do not choose in the Thank You wizard, Redirect to an external link. How can I get POST data in this case?
    My form appears in the modal window. I want that Thank You would appear in the modal window too on the same page. I don't redirect the user another page, but I need to get POST Data on the other URL
    Thank you!
    11 апреля 2017, 19:43:23, от JotForm < noreply@jotform.com >:
    A new response has been received: [IMAGE]Answered by Kiran We have a guide that helps in sending the submissions to MySQL database using PHP. http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP Since you want to connect to the MSSQL database, you may be using ASP to send the data. The process is the same that might help with the above guide. You may enable the POST Data from the form settings so that the form submitted data can be sent to an external data source using POST method. You may create a new file that connects to your MSSQL database and process the POST data to the database.  Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help.  View this thread on browser » Unsubscribe Thread 1491929015
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on April 12, 2017 at 04:48 AM

    If you do not wish to redirect your users to the PHP script or where you will send the POST data, then you can do that by setting up a Webhook instead. Here's a guide about it: https://www.jotform.com/help/245-How-to-Setup-a-Webhook-with-JotForm

    So instead of having the target PHP or URL on your "Thank You" page, you'll need to set it in your WebHook integration. Make sure to set your "Thank You" page back to the custom message if you do not want to redirect. 

    I hope that helps. 

  • Profile Image

    Answered by pavelgon on April 12, 2017 at 05:44 AM
    Excellent. It's like what I need. Thank you so much. My client will be pleased. )
    12 апреля 2017, 11:48:25, от JotForm < noreply@jotform.com >:
    A new response has been received: [IMAGE]Answered by Charlie If you do not wish to redirect your users to the PHP script or where you will send the POST data, then you can do that by setting up a Webhook instead. Here's a guide about it:  https://www.jotform.com/help/245-How-to-Setup-a-Webhook-with-JotForm .  So instead of having the target PHP or URL on your "Thank You" page, you'll need to set it in your WebHook integration. Make sure to set your "Thank You" page back to the custom message if you do not want to redirect.  I hope that helps.  View this thread on browser » Unsubscribe Thread 1491986919
    ...