Large volume drop down list

  • doctoblog
    Asked 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

  • jonathan
    Replied 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.



  • doctoblog
    Replied on January 26, 2020 at 5:50 PM
    How would you use multiple lists?
    Set a condition between the form fields?
    www.docto.com
    ...
  • Welvin Support Team Lead
    Replied 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.

  • doctoblog
    Replied on January 26, 2020 at 7:50 PM
    I 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 Lead
    Replied 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.

  • doctoblog
    Replied on January 27, 2020 at 2:50 AM
    Thanks
    Jon
    www.docto.com
    ...