Connect to database before submisson

Hello,

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:

http://www.readyofferstool.com/paymentProcessing 

Use "1234567" as the dealer number to populate the fields.

Thanks!

Chad Austin

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.