Connect to database before submisson

  • Profile Image
    caustin
    Asked on January 05, 2016 at 05:49 PM

    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

  • Profile Image
    victor
    Answered on January 05, 2016 at 08:22 PM

    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.

  • Profile Image
    caustin
    Answered on January 06, 2016 at 12:38 PM

    Due to PCI compliance, we are not able to pass parameters through the URL field. The search needs to be done within the Jotform.

  • Profile Image
    victor
    Answered on January 06, 2016 at 01:59 PM

    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.