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.
Conditional filling with 5,000 optionsAsked by guilhermevc on May 24, 2016 at 10:41 AM
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.
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.