Auto Populate Jira Custom Field Based on Values in Another Custom Field

I have a custom field called Client Name. I would like to auto-populate another custom field called Client Code based on the value in the Client Name field. Is there a way to build a database table containing client codes?

Thanks,

Kay

3 answers

1 vote

Hi, Kay. When do you want to set this value? On creating the issue?

If it is the case, you can do it with post functions and the JIRA Suite Utilities plugin, here:

About post functions: https://confluence.atlassian.com/display/AOD/Advanced+workflow+configuration#Advancedworkflowconfiguration-postfunctions

JIRA Suite Utilities: https://marketplace.atlassian.com/plugins/com.googlecode.jira-suite-utilities

Simply install the plugin and then, when creating a post function, you will have the "Copy value from other field" option. You can use this on the 'Create' transition, to copy on creation, or on any other transition.

If you want to set the field on already created issues, you will probably need to use SQL on the database. This is something more advanced.

I hope it was helpful.

That is much more advanced.

Where is the data mapping code and name, in a database?

Hi Jaime, Yes, the information is in a database. Regards, Kay

I advise you to look for a plugin in the Marketplace: https://marketplace.atlassian.com/. There may be one that helps you with that. Cheers.

Thank you, Jaime! Regards, Kay

Hi Jaime,

I want the Client Code value to auto-populate when data is entered into the Client Name field. The Client Code is unique for each client. The Client Code would not be an existing value, it would be a new value that does not exist in the ticket.

Thank you,

Kay

Hi, Kay. I'm not sure exactly how, but I think you can accomplish that with post functions: https://confluence.atlassian.com/display/AOD/Advanced+workflow+configuration. Give it a look and see the ones available. Cheers!

Hi @Kay Brown, @Jaime Silveira

I have the same requirement. Will you be able to achieve that?

 

thanks,

Rosy

Well, in general you can only set fields automatically on transitions. So, if you want to do this during a transition, there are post-functions that allow you to copy values from a field to another. I'm not sure if an add-on won't be necessary, depending on the situation and the environment, you should check the available post-functions.

Otherwise, you can give 'ScriptRunner' a try. It may also help in this case.

You can read about post-functions here:

https://confluence.atlassian.com/adminjiracloud/advanced-workflow-configuration-776636620.html

thanks Jaime! however, I wanted to do that independently from the transition, it should be triggered each time I populate the value of the field. Should I use event listeners to do that for the change of the issue?

 

thanks,

rosy

Hi Rosy,

No, I was not successful in achieving this goal.

Regards,

Kay

Hi All, I too have a similar requirement to auto populate a drop down with list of values based on another dorp down custom filed.

If the first filed value is EI, then the second drop down should list all the EI defect types like CR & PR. And if the first filed value is PD, then the subsequet dorn down should list only the PD defect types.

Please let me know, how to achive this in JIRA ?

Nanda,

Did you ever get an answer to this? I was able to do this with drop-down selection lists.  I have yet to be able to do this for the case outlined by the OP, but this one I have an answer for if you still need it.

Regards,

Clint

And the answer is..... ? :-)

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,307 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot