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 access the data from my forms programmatically?

    Asked by Winston on June 28, 2012 at 10:58 PM

    I'd like to get or put field data on the database holding my data programmatically through HTML or, if possible, from my PC. 

     

    Thanks.

     

    Winston Negron

    Page URL:
    thewinstonmethod.com

    Database Fields My Forms
  • Profile Image
    JotForm Support

    Answered by jonathan on June 28, 2012 at 11:08 PM

    Perhaps you can check this guide -How-to-Insert-or-update-form-submissions-to-your-MySQL-database-using-PHP to get a general idea on how you can pull data from jotform forms into the database. The guide involves PHP and MySQL

    It will require know hows on PHP programming and databse creation/implementation.

    Hope this help. Please inform us if you have any other inquiry.

    Thanks.

  • Profile Image

    Answered by Winston on June 28, 2012 at 11:21 PM

    Thanks for you prompt reply.  However time constraints prevent me from delving into PHP at this time.  I'll see if I can find a work-around.

    Winston

  • Profile Image
    JotForm Support

    Answered by jonathan on June 28, 2012 at 11:42 PM

    Hi Winston,

    There are actually a more simpler method that will only involves downloading the submission reports of your form as CSV or Excel data format. Or integrating your form to google spreadsheet.

    If you have the facility to IMPORT data out of CSV, Excel or spreadsheet data formats, there maybe NO need for any programming development to get the information into your database.

    Example, using PhpMyAdmin in MySQL or ISS in MS SQL will allow importing of data from raw formats into a database table.

    Hope this information helps.

    Thanks.

  • Profile Image

    Answered by Winston on June 29, 2012 at 12:31 PM
    Thank you, Jonathan; I appreciate your support.

    I'm pretty good with databases and I was aware of what you're suggesting,
    which is simple for me to do. What I really want to do is the following:

    When a user goes to a certain form on my website, I would like to compare
    his/her imput with data he/she had previously entered on another form to
    determine what action to take - an if/then scenario, if you will. E.g.,
    when a user enters his/her name on a form field, the form "fetches" values
    related to him/her from a previously filled form.

    I sort of think this should be possible with some HTML right from your
    forms. Am I wrong?

    Winston

    _____
  • Profile Image
    JotForm Support

    Answered by Mike_T on June 29, 2012 at 04:46 PM

    I am sorry to inform you, but we do not have any similar feature.

    I believe that you will need to use some programming language besides markup HTML to accomplish this. Since we do not provide direct access to the Submissions Database things may be even more complicated. You can also get your data using some online Report.

    Thank you for using our services.

  • Profile Image

    Answered by khrisell on July 05, 2013 at 12:23 AM
    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. :)