Quickly add list of inputs to dropdown menu?

[Southy567]

Hey all!

Hoping you can help. I am currently building a dashboard that will allow users to select a option from a dropdown menu, and then type in a username in order to see all events for that input for that user.

I am in a bind however as the dropdown has several hundred options (unfortunately no way to slim that down) and I was wondering if there was a way to quickly and painlessly add the labels and inputs from a spreadsheet I have over into the dropdown, or if I have to go through and copy each of them individually.

Any help would be greatly appreciated!

[richgalloway · Accepted solution]

You should be populating the dropdown list with a search.  That search get collect values from your indexes or can get them from a lookup file (or other places).  In the form below, your SPL (perhaps | inputlookup options.csv) goes in the "Search String" box.  The name of the field you want to show to users goes in the "Field For Value" box.