How to use an indexed list as input for a "dropdown list" issue field?

[Christopher Brown]

Currently I have an indexed list of serial numbers 1-100.

In my Jira software project, I want to create a dropdown list as a field in one of my issue types that lets me select any of the values between 1 and 100 incremented by 1.

Currently it appears I can only add one option at a time and manually add each entry to each option. I want to add two serial number fields and it seems quite repetitive to have to do this manually 200 times.

[Thomas Opiolka - codefortynine]

Hi @Christopher Brown ,

Another creative way to automate your process could be achieved by using the "External Data for Jira Fields" app, specifically with the Field Options Sync feature. Here's a simplified step-by-step guide:

1. Generate a JSON file using a tool like https://json-generator.com/. This website enables you to create a JSON file based on specified rules, for example, numbers 1 to 100.
2. Upload this JSON file as a data source in the app.
3. Configure a Field Options Sync in the app to synchronize with the desired native Jira field.

It's worth noting that you don't need to keep the app installed in case this is a one time operation. I should mention that I am collaborating with the vendor of the app I recommended.

I hope this is helpful.

Regards,
Thomas

[Trudy Claspill]

Hello @Christopher Brown 

Before addressing the creation of those option values...

It looks like you might be working with a Team Managed project. Is that correct? If so, in Team Managed projects a Dropdown custom field is limited to 55 entries. So, in such a project you cannot create 100 entries for a dropdown with any method. There is a change request about increasing the limit.

https://jira.atlassian.com/browse/JRACLOUD-77917

As to adding multiple option values in a more efficient way you might accomplish that by using the REST API.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-custom-field-options/#api-group-issue-custom-field-options

It might also be possible to add the options by importing issues from a CSV file where each issue in the file has one of the values. I haven't tried that for quite some time, so I'm not sure if that still works.