Scripted field- Check box field converted to numeric field

Question

Hello Everyone!

I have a scenario where I would like to convert the data in a checkbox field to a numeric field. For example :

Checkbox field: Option A, Option B

I would like to assign a numeric value to the options: Option A = 5pts, Option B = 10pts

The scripted field would show the total.

So if both options were checked the scripted field would show 15.

Is this possible?

Matt Gudenas · Answer

Interesting - I suppose you have a slightly different use case to what I thought. Nonetheless, I am glad it works for you now!

Duane Cronkite · Answer

I ran it through chatGPT and this made it work. Does this make sense?

import com.atlassian.jira.component.ComponentAccessor

// The issue type for which we want the scripted field to be displayed
final issueTypeName = 'Story'

// Replace with the field name that you want to run this against
final multipleChoiceFieldName = 'Multiple choice'

if (issue.issueType.name != issueTypeName) {
return null
}

// Fetch the custom field object by name
def multipleChoiceField = ComponentAccessor.customFieldManager.getCustomFieldObjects(issue).findByName(multipleChoiceFieldName)

if (!multipleChoiceField) {
log.debug "Custom field is not configured for that context"
return null
}

// Get the value of the multiple choice field (checkboxes)
def val = multipleChoiceField.getValue(issue)

if (!val || !(val instanceof Collection)) {
return null
}

// Replace the options with whatever the checkbox options are
def sum = val.collect { option ->
switch(option.value) {
case 'Option A': return 10
case 'Option B': return 5
default: return 0
}
}.sum()

return sum

Matt Gudenas · Answer

The field type shouldn't matter here - are you sure that the options and the field names match exactly?

Try putting some log.debug statements after each line to see where it breaks.