Setting a Numeric Custom Field to a value based on the selections of a Dropdown Custom Field

[Neil Berent]

We've received a request to assist with setting up a dashboard containing the SumUp gadget, with the hopes of providing a sum of Story Points and Credits. Up to this point, these two fields were set in projects as free-form dropdowns, containing strings. Because of this, the sum of the Story Points and Credits for the applicable issues is displaying incorrectly.

For example, if an Issue has 1 story point in the dropdown, it is being displayed in the SumUp gadget as "11874". If it is 30, it displays as "11903". As a workaround for the time being, I've added in two numerical fields that reflect the same name. The numerical field value display correctly in the gadget. However, I'm hoping that we can avoid much manual work for our users by mapping the already existing values in the dropdowns to their accurate values in the numerical fields.

Is this possible to do with a script? The Story Points range from 0-100, and the Credits range from 0-10. I have it mapped out in an excel spreadsheet, but I'm not a coder. Do we need to run a specific script through Script Fields? If anyone can advise what the easiest step would be for everyone involved, I would appreciate it.

Thanks!

[Alexandra Holom · Accepted solution]

Hello @Neil Berent

I am a developer from Decadis, the company that develops sumUp, and I want to clarify some things for you.

First of all, the values that you see in your gadget are the IDs of the select list options.

Unfortunately it is not possible to sum those option values with sumUp.

I don't think there is a simple out of the box solution for your problem. So my suggestion would be to use a scripted field for each value (Story Points and Credits) in which you read the field values from the select list, and then create sumUp rules for those 2 fields and sum those values up by checking the non-indexed field checkbox.

I am sure this is not ideal, but it's a solution that would work.

Best regards,

Alexandra

[Neil Berent]

Hi Alexandra,

After going through several similar posts in the Community forums, that's what I was thinking as well. I haven't had much experience with scripting within Jira. Is there perhaps a sample script that can be forwarded to me and I'll just fill in the blanks?

Appreciate your help.

Neil

[Neil Berent]

Please disregard. I've just decided to use the Bulk Edit feature to filter based on existing story points and adding in the new values.

Thanks!