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.
Connect to database before submissonAsked by caustin on January 05, 2016 at 05:49 PM
We've built an application that allows for us to reference customer data before passing it into a payment portal (iframe). Our concerns are around PCI compliance of the iframe, but we see the value in reference the database to populate form fields.
The question is, can we connect the database to jotform in order to populate the fields without submitting the actual form for processing?
You can view a sample of the concept at:
Use "1234567" as the dealer number to populate the fields.
Can you please elaborate a bit more on what you mean on populating the form with out submitting? If I understand you correctly you would like to search your database and pre-populate this information into your form.
I suggest you review our users guide, Prepopulating fields to your JotForm via URL parameters. Once you have capture the information from your database, you can open a new window where your form is and pass the values using the URL.
Please let us know if this help.
Due to PCI compliance, we are not able to pass parameters through the URL field. The search needs to be done within the Jotform.
Unfortunately, there is no way to connect to the database from JotForm. You would need to use the source code an make your adjustments to accomplish this.
The only possible work around would be to embed your form using iFrame. In your page have a search button, as you have. When users enters the proper code, this would open or show your form with the proper information. In the iFrame you would just need to modify the URL as indicated above:
<iframe allowtransparency="true" src="//form.jotformpro.com/form/xxxxxxx?fullName3[first]=John&fullName3[last]=Doe" frameborder="0" style="width:100%; height:562px; border:none;" scrolling="no"></iframe>
Either way, you would still be populating values through the URL.
At the moment this would be the only possible ways to do this.