Conditional filling with 5,000 options

  • Profile Image
    guilhermevc
    Asked on May 24, 2016 at 10:41 AM

    Hello,

    How can i fill a text field with a condition? Sample: I have a client excel database with two columns (ID and Name) and 5k rows, i'd like to fill a text box with a client ID and it automaticaly fills another field with a client name.

     

    It's possible?

  • Profile Image
    Charlie
    Answered on May 24, 2016 at 12:20 PM

    This is not possible using our Conditional Logic feature. But it's possible if you'll use the form's full source code and have a custom script that will fetch data from your database (you need to import your excel in a database like MySQL) and auto fill it on your form. However, you'll need to have knowledge with programming or hire a developer for this setup. You'll also need to have a web page where you can place your form's full source code.

    Here's how I'll set it up:

    1. In my web page, I'll paste my form's full source code.

    2. I'll then create a custom script that will fetch data from my database and auto fill it as defined variables in my form's fields directly on the full source code.

     

    I hope that helps.