- pamballAsked on July 12, 2012 at 05:43 AM
- JotForm SupportjonathanAnswered on July 12, 2012 at 06:12 AM
You may want to check this guide -How-to-Insert-or-update-form-submissions-to-your-MySQL-database-using-PHP It will involve PHP and MySQL.
Alternatively, you can also make use of the form submission reports download (Excel or CSV) data. Once data are downloaded you can import the data to your database thru connectors or driver interface.
Quite frankly, JotForm do not have yet the feature of a "one-click" direct export or import to databases schema or table (in case you are looking for such feature).
Hope you find the information helpful. Feel free to contact us if you have any other inquiry.
- pamballAnswered on July 12, 2012 at 06:32 AMBasically what I am looking to do is to have a hidden form field (which I already have in place on my form) and when the form is submitted I would like for that field to be completed automatically by connecting to the database.
Ex. Member of an organization signs up for a workshop and the form connects to the database to include the member’s member number.
- JotForm SupportjonathanAnswered on July 12, 2012 at 06:54 AM
If I understand correctly, you wanted that 'hidden number field' to have value that comes from your database. As is, I cannot see any way for you to do this using the form out-of-the-box or using the form builder alone.
But if you can use the form source code and deploy it in your own website page, you can inject custom function or a develop full application outside jotform that can connect to your database and populate the 'hidden field' after some series of instructions.
I have seen a user do this using XML interface to connect to the database, then uses http parse to get the data and simply insert the value to the hidden field.
I have not tried, but I think the JotForm google spreadsheet integration is as good as database or data source also.
Please do not misunderstood what I am trying to convey here =) I just wanted to share the idea which I have personal experience only. I do not want you to have false high expectation.
Becasue as is, we still do NOT have the JotForm feature to connect directly or in a "10 step" process to a database.
- pamballAnswered on July 12, 2012 at 07:05 AMThank-you! I was thinking I was going to have to go back to an old fashion tedious html form and use php to connect. I am working this but the other problem lies in that I have to be able to integrate the payment also and the website I am using does not have a secure server hence the jotform connection, :0)
Thank-you for your help though….
- JotForm SupportjonathanAnswered on July 12, 2012 at 07:13 AM
Actually, if you have know how on the "old fashion" html form and PHP, the JotForm form is way better than the old fashion html form. You can absolutely use the form source code (html) and use PHP for custom functions/instructions.
I am not a programmer though... specially on PHP. I would have love to take on the challenge.
How about I create a sample basic form that populate a hidden field out of a data source.? I can present this to you and maybe you may find it useful one way or another.
But I do not want you to linger on this. If we have it, then thats a plus.
- pamballAnswered on July 12, 2012 at 07:21 AMIf you want to feel challenge then by all means be my guest….I have only done some research on this….I actually have a couple of website I will need to do this with and if we can use the jotforms even better. I love the way they look and act on a website, :0)
I wasn’t going to be able to do anything else on this until Monday anyway so if you are able to figure out that part for me wonderful!
- JotForm SupportjonathanAnswered on July 12, 2012 at 07:48 AM
Thank you for considering our service and JotForm. I'll see what I can do.. =)
Hopefully I can provide you something within the weekend.
- pamballAnswered on July 12, 2012 at 08:26 AMThank-you!
- khrisellAnswered on July 05, 2013 at 12:35 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. :)