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

[Deleted user]

Hi everyone,

I want to populate the 'Department' drop-down 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

Please be aware, Department is a drop-down field

[Deleted user · Accepted solution]

‎ ‎ 

[Vamsi Kandala]

Hi @[deleted]

If I understand correctly, you want to populate the 'Department' drop down field every time the ticket was created.

Does the field will have a single value every time or do you want to keep appending the 'Department' field as the tickets get created?

If it is the first scenario and if the issue description always follows the above template, then you can use the combination of automation rule and smart values.

Enclosing the article of various examples to use with string smart values.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/

Hope this helps.

Thanks,
Vamsi

[Deleted user]

Hi Vamsi, the Department field has specific values in it.

I've tried {{issue.description.substringBetween("Department:"," -")}}{{issue.Department}} but it doesn't work for drop-down fields