How to Create a DropDown list of Code Field from Excel Table to Fill the data in other fields

Dear Team,

Have another question with regard to the Widget "Spreadsheet to Form".

In current scenario, when use this widget "Spreadsheet to Form", an Excel Spreadsheet can be uploaded and a field can be selected as a code to populate data in rest of the fields in the Form connected with the code. But it is not very handy to remember the list of codes. Therefore, I would like to know if a solution is available for my following problem.

I have created a spreadsheet with data in it.

I want the code field in the form to appear as dropdown list, displaying the code field data from excel spreadsheet.

When user select the code, it should automatically fill the rest of the fields based on it, as it normally does.

Kindly help a solution with this problem.

Thanks and regards

Riz

Hi Mohammad,

Thanks for reaching out to Jotform Support. Let me look into it and get back to you with a solution.

We really appreciate your patience and understanding while we’re looking into this.

Hi Mohammad,

I looked over your request and currently, it's not possible to have the code field as a dropdown list. While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know.

Let us know if there’s anything else we can help you with.