For an individual issue, populate a NEW field's value based on the value in an existing field

[Lisa Hooper]

I have created a new field (ex: CITY) and I need to populate the field based on a list I currently have in excel.  

LOCATION  CITY

P2               Dallas

P3               Houston

etc.

Can I create a script that will prevent me from editing every issue and allow me to do a bulk edit of a list of 150 issues? Each with different values in each field.

[Lenin Raj]

Hi @Lisa Hooper, 

Bulk edit may be possible depending on how much different the values can be for each issue? Is it based on another field in the issue? If so, you can filter for that using JQL and use the 'Bulk Edit' option in the page.

[Lisa Hooper]

Thank you for such a quick response.  Using Bulk Edit I would still have to search for every issue with Location = one value, and populate the field City = with another value.  No two sets of values are alike.  What I'd like to do is create a script to change multiple issues at one time. 

[Lenin Raj]

@Lisa Hooper 

If you have some scripting knowledge, I believe this is possible to do. I searched for any related posts in the community and found these:

https://community.atlassian.com/t5/Jira-questions/Jira-field-calculated-based-on-another-field/qaq-p/164008

https://community.atlassian.com/t5/Jira-questions/How-to-dynamically-set-a-field-based-on-another-field-value/qaq-p/819500

https://community.atlassian.com/t5/Jira-questions/How-do-you-set-a-field-to-change-the-value-depending-on-another/qaq-p/934151

I hope these are helpful. Let us know otherwise.

[Lisa Hooper]

Thank you.  I may have found an easier way with the following video:

https://www.youtube.com/watch?v=Bml_jtln70Y

I'll give it a try then check out the scripts.  Thank you.

[Lenin Raj]

Sounds good, let us know how it goes.

[Lisa Hooper]

The CSV Import worked perfectly!  Super easy.