How to automatically populate issue fields based on issue's description

[Deleted user]

Hi everyone,

I want to populate the 'Department' field based on the issue description. 

Example -

Issue Description:
Employee Name: FirstName LastName - ‎ Employee Location: USA - ‎ Employee Department: Marketing - ‎ Employee Title: Graphic Designer - ‎ ‎Employee Personal Email: testuser@gmail.com - Employee Manager: FirstName LastName 

Automation grabs 'Marketing' from the issue description and puts it into the 'Department' field

[Deleted user · Accepted solution]

‎

[Rilwan Ahmed]

Hi @[deleted] ,

This can be done using smart values in the Automation rule.

Please follow below steps

Go to Project settings --> Automation --> Create rule --> Issue created
New action --> Edit Issue
Select "Department" field in the "Choose fields to set"
Add below line in the text box
{{issue.description.substringBetween("Department:"," -")}}{{issue.Department}}
Click Save.

Please note: Department field should be a text field. 

Rule should look like below 

[Deleted user]

Hi @Rilwan Ahmed

Thanks for your assistance, I should've mentioned this but Department field is a drop-down field with set results, 'Marketing' being one of them. I tried putting 

'{{issue.description.substringBetween("Department:"," -")}}{{issue.Department}}' into a variable and then placing it into the Department field, however it didn't seem to do anything. Is there anyway for me to get it to work with a dropdown field?

[Deleted user]

Hi @Rilwan Ahmed

Do you have any advice regarding what I've posted?

[Rilwan Ahmed]

Hi @[deleted] ,

Sorry for the delay. I am not aware on how to do it for drop down fields. But please go through this link and check the section Jira smart values - List. This will sure help you to know if its possible or nor