-
doctoblogAsked on January 26, 2020 at 2:53 PM
Hi guys, I have a large list ( csv file) I would like to populate a dropdown list. I want user to be able to type the initial letters so the field populate alphabetically
I can copy and paste the column into your standard dropdown list question but it there seems to be a max number of values that are read...
What's the best way to do this?
Jon
-
jonathanReplied on January 26, 2020 at 4:06 PM
...but it there seems to be a max number of values that are read...
This is correct. There is a number of character limit set on the Dropdown list.
Please take note that the limit is not the number of options -- but the number of character/letter you can put in the dropdown list. In other words, you can have 100 options with 10 chars per option or you can have more than 100 options with less than 10 chars per option.
The possible workaround you can do is to use multiple dropdown list to breakdown the list options to smaller character number limit.
---
I want user to be able to type the initial letters so the field populate alphabetically
As to this option/feature, you may use instead the Auto Complete widget https://www.jotform.com/widgets/autocomp
The regular dropdown list does not have this feature.
But do take note that similar to dropdown list, the Auto complete widget also have the number of character limit that can be used on it.
I hope this help. Let us know if you need further assistance.
-
doctoblogReplied on January 26, 2020 at 5:50 PMHow would you use multiple lists?
Set a condition between the form fields?
www.docto.com
... -
Welvin Support Team LeadReplied on January 26, 2020 at 6:58 PM
You can add a new dropdown with another set of options, especially the ones that are cut off on the first dropdown. You do not need conditional logic to do this, you can show the dropdowns and let users select an option.
What I can suggest is to conditionally unrequire fields based on the selection. For example, set dropdown 2 and dropdown 3 as not required when dropdown 1 is filled. That way, users are not forced to fill all dropdowns.
https://www.jotform.com/help/367-How-to-Make-a-Field-Required-Based-on-User-s-Answer
I hope that helps. Please let us know if you need further assistance.
-
doctoblogReplied on January 26, 2020 at 7:50 PMI would need to add a new dropdown list for every letter of the alphabet so
this is messy.
I'm surprised this isn't a feature.. it seems to be standard on other
providers e.g. formstack.
Is it likely to be available in the future?
Jon
www.docto.com
... -
John Support Team LeadReplied on January 27, 2020 at 1:08 AM
Hello Jon - Have you tried the Auto-complete widget that my colleague has suggested? I guess this might achieve the requirement in providing related options as soon as you enter a letter.
Here's a demo form: 33356981507865
Also, regarding the "populate alphabetically", could you please provide further details about it? Do you mean the options in the dropdown list should be in alphabetical order? I think if you're going to import the options from a CSV list, you can try sorting them first in alphabetical order before pasting it to the dropdown list, though, as my colleague has mentioned, there were limits on how many characters you can add in the options list.
-
doctoblogReplied on January 27, 2020 at 2:50 AMThanks
Jon
www.docto.com
...