It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Set field value at creation, based on max field value

I have a field, "Name", that I'd like to set automatically when an issue is created.  The values of this field will be in the form "Acme101623":

  • "Acme":  This is the same for every issue
  • "1016":  This is the current month and year.
  • "23":  This is a sequential number, starting at "01" at the beginning of the month, then will increment by 1 each time an issue is created.

So, for the next issue, I'd need to see all other issues where this field is "Acme1016nn", then increment the highest "nn" value by one to find the next value.  How can I do this?

Thanks,

-Scott

1 answer

0 votes
Nic Brough Community Leader Nov 02, 2016

You'll need to write code to do this.  I'd keep it as simple as possible - a post-function that puts your data into a standard "read only custom field" (Those are intended to be populated by code).  As usual, I'd do it with the Script Runner, but creating an add-on to contain the post-function would work fine too.

The Acme, month and year are quite easy to do.  The sequential number is a bit more of a problem.  You'll need to store that number somewhere, which isn't that hard (active objects if you're coding your own add-on.  Script Runner, I'm less sure of), but you could run into "fun" with concurrency when two users are creating issues at much the same time.

Before you dive into piles of code though, could you explain the requirement from the users point of view though?  There might be a better way to meet the need.

 

I'm migrating our asset tracking database to Jira.  This is the machine name, which follows this structure.  In the old system (a spreadsheet) it was easy to see what the most recent value of this field was and pick the next one.  

I'll look into script runner. 

Thanks,

-Scott

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

1,099 views 7 0
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