Convert string to a specific value

Wolff Sébastien

Hello,

 

I have a select list (single choice) with this different choices :

- Minor

- Major

- Critical

- ...

I need to use this field in an automation to calculate another field on the request.

For this, i need to create a variable to set the numeric value for each option. 

- Minor : 1

- Major : 2

- Critical : 3

- ...

 

Is there any function to create this variable ? I try to use the function "if" when i create the variable, but it doesnt work.

Thank you for your help.

 

Bill Sheboy

Hi @Wolff Sébastien -- Welcome to the Atlassian Community!

There are several ways to do this:

• if / else conditions
• conditional logic
• lookup table

I recommend trying a Lookup Table for this: https://community.atlassian.com/t5/Automation-articles/Update-Create-lookup-table-action-improvements/ba-p/2427798

For example, the table keys could be the name for the possible selections and the value could be the number.  Then the get() function would return the value:

{{tablePriorityToScore.get(issue.myCustomField.value.name)}}

 

If that does not help, please post an image of your complete automation rule and audit log details to provide context for the community to offer suggestions.

 

Kind regards,
Bill