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

Christopher Brown March 28, 2024

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.

Screenshot 2024-03-28 at 12.14.03.png

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.

2 answers

0 votes
Thomas Opiolka
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 31, 2024

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

 

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 28, 2024

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events