Dynamic Form With Rules Of Filtration

Hello, i have a excel that has 4 columns:

A B C D

The thing is that the first value to select is A and then the answers of B depends selection of A. When you select B it will give you other value in C Option and selecting C option witll give you D option . Having 4 dropbox dynamically.

Brand Car

Model Car

Year Car

Version Car

The thing is that there are different combinations because the year car has an specific versions that changes depending in year.

Which is the best way to get this function working, because there are more than 10,000 values combinating Brand Car,Model Car, Year and Version. Thanks.

Hi smartnewsletter,

Thanks for reaching out to Jotform Support. Actually, the only way to import a datasheet into a form is the Spreadsheet to form widget. As explained into this guide, this widget needs a spreadsheet in which one column is defined as the access key to automatically fill out the fields in the form with the data from the other columns, the column names and the fields names being the same to be mapped accordingly. This implies access keys to be unique to make such a mapping working because each field to be mapped can get only one answer, as for instance a short text element, or a dropdown menu element. In other words, the Spreadsheet to form widget doesn't work like a filter, but like a pointer.

A quick look at the first lines of your datasheet shows that you can have multiple entries being the same, with thousands of entries. The feature you're asking for is typically a database management system, such as SQL, and to make a database query working on a website, I would suggest connecting a database system to a dedicated web interface based on, as for instance, PHP, or Node.js. Unfortunately, when our database integrations can update a database with the data coming from a form, a form can't yet be dynamically updated from the data coming from a database, even by the means of our API.

And, unfortunately, the large amount of data, and the possibility for your data to be updated, makes unpractical the use of the form conditional logics to make the forms dynamic by showing/hiding form elements. Your case will require a large amount of conditions, which will require to be updated each time your data are updated.

So, since this feature isn't available in Jotform right now, I've gone ahead and escalated your request to our developers, asking to be able to update various form elements with a spreadsheet or a database management system, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.