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 can I submit form results to my own database table for use in other parts of my site?

    Asked by grayceworks on February 06, 2011 at 05:06 AM

    I am creating a site where I need a complex form with conditional formatting such as what I've designed here, however, when the form is submitted, I need a way to store those values in a separate database, in order to access and display the results using a query.

     

    I also need to be able to autofill a couple of the form fields based on info already in my site's database for the logged in user.

    Willing to pay for the extra support and/or upgrade membership as needed.

    Any hints or ideas? Thanks!

    Form Builder Submissions send post data
  • Profile Image
    JotForm Founder

    Answered by aytekin on February 07, 2011 at 04:03 AM

    You can accomplish that using Send Post Data feature. It will post the POST data to your Thank You page. You can enable it from Preferences button on the toolbar. 

  • Profile Image

    Answered by grayceworks on February 07, 2011 at 04:06 AM

    Ok, I understand that will put the submitted info on the thankyou page, but from there, how does it get to my database? I don't see where I can enter code to insert into my mysql database?

     

    I also need to be able to insert code somewhere to retrieve existing info from my database and fill certain form values with it.

     

  • Profile Image
    JotForm Founder

    Answered by aytekin on February 07, 2011 at 09:31 AM

    If you make your Thank You page a PHP page, you can connect to Mysql from PHP and insert the data into one of your tables. 

  • Profile Image

    Answered by grayceworks on February 07, 2011 at 10:16 AM

    Can I use standard Joomla variables to do this? Or do I need to manually include all the database connection info?

  • Profile Image
    JotForm Founder

    Answered by aytekin on February 07, 2011 at 10:18 AM

    JotForm will send the variables using HTTP POST. After that it is up to you. I don't know about Joomla variables, so I cannot say anything. You should probably hire a programmer. 

  • Profile Image

    Answered by khrisell on July 04, 2013 at 11:08 PM
    Greetings!

    We are happy to announce that we have released Jotform Webhooks,  this feature would replace Send Post Data + Custom URL Thank You Page workaround in order to help you transfer forms data to your own database using your own script codes.

    To know more about Jotform Webhooks, please click here.

     

    Thank you for using JotForm. :)