What's the best practice for a custom, single-select field with 100 options?

[Nancy Bonanno]

Our company will match any donation you make to certain charitable organizations.  Users can put in a Jira ticket with an attached receipt to say, "I made a donation of this much to this organization."  The trouble is the "Accepted Charitable Organizations", which is a single-select custom field, has at least 100 values to select from.  And it is updated frequently, which is very tedious.

Does anyone have a good solution?  Is there any way to have the user control the list of values?  Or can the values be pulled from some outside source, like a confluence page?  Or our director has suggested using something called AWS Compare, but I don't know what that is.  Are there solutions out there?  Thanks.

[Mohamed Benziane · Accepted solution]

Hello @Nancy Bonanno 

You can use a label field, but you can have various value for the same organization like below:

label 1 : redcross

label 2 : red cross

label 3 : RedCross

All these labels are for one organization. If you want the value be pulled from outside source you need an addon or write some script.

You can also add value in customfield using csv but it's manual.

https://confluence.atlassian.com/adminjiracloud/importing-data-from-csv-776636762.html

[Nancy Bonanno]

Okay, thanks.