- WinstonAsked 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.
Winston NegronPage URL:
- JotForm SupportjonathanAnswered 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.
- WinstonAnswered 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.
- JotForm SupportjonathanAnswered on June 28, 2012 at 11:42 PM
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.
- WinstonAnswered on June 29, 2012 at 12:31 PMThank 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?
- JotForm SupportMike_TAnswered 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.
- khrisellAnswered on July 05, 2013 at 12:23 AMGreetings!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. :)