Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,682
Community Members
 
Community Events
165
Community Groups

How do you create a calculated field that concatenates 3 previous fields in the same form

I have a form that needs to generate a field that is the result of three previous dropdown fields.  This calculated field needs to hold several values.  For example: 

accessFld is a result of prodFld + "-" + platformFld  + "-" + accessTypeFld

The result would be something like:

marketing-dev-devops

sales-pro-audit

sales-pro-manager

How would you trigger automation to repeat the input of the three fields?  Is such a thing possible in Jira?  Otherwise how would you do something similar in the Jira world?  

1 answer

@Joe Bedolla -

Welcome to the community.  There are two options that you can look into for your ask -

1) Create a scripted custom field by using Script Runner for Jira 3rd party add-on (This is an excellent paid add-on that should be used in any Jira/JSM implementation in my experience/option) - https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?tab=overview&hosting=cloud

2) Using Automation for Jira (an out of the box component in Cloud env for Jira/JSM) to create rule which triggered from Issue Updated event to execute an edit issue action to update your custom field with values from your other fields.

One thing that you need to be aware is what is the data type associated with your three other fields?  If you just want to concatenate everything as a single string (text), then it should be straight forward. 

Lastly, since the field is a calculated field, then it should only be added to your project's View Issue screen (Screen Configuration Scheme) because it is sourced from your other fields.  Your users (agents) should not be able to edit this field.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

I'm using Jira Cloud so Script Runner is not an option. Is it possible to trigger the fields to refresh from within the form?  I need for the user to be able to add several values to the calculated field.  How would you be able to trigger such a thing?

@Joe Bedolla -

ScriptRunner for Jira is available for Cloud.  However, if cost is an issue.  You will need to look into my 2nd recommendation (mentioned in my original suggestion) on using Automation for Jira to establish rules.

Here is a link to Automation for Jira (it is build into the Cloud env from Atlassian) -

https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/

Best, Joseph

Thanks Joseph!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

217 views 0 6
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you