You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Right now I'm using Service Management free plan. I would like to create a custom field with an auto generated value for my issues. The value I want is a series of number combined with the date and the number of issue key.
I want to value would be YYMMXXXX (Y=year, M=month, XXXX=number part of the issue key). For example, today is Oct 2023 and the issue key of the newly created issue will be ABC-5, then the value in the field will be 23100005.
Is it possible to be created? (even with JQL or other programming method)
Hi @Dearka Chan
You can du this with Automation and apply this to your custom field
Here is an example of such rule. Notice I used the Summary field, but you shuld change that to your customfield.
The result will be like this:
I now see that you don't want the day. Simply remove "dd", so it is like this:
Notice MM must be capitalized.
Thank you, it really helps a lot. By the way, if I want to recalculate the issue number in the start of every month, can the last part of the value changed from the number part of issue key to the issue number of this month?
For example, the next issue is the 6th issue in this month, can the value be 23100006?
Hi @Dearka Chan
I see. Change the rule as shown below.
You will need to find all issues created in this month and then use lookupIssues which will contain those issues. Then you can use the smart value function size to fetch this "counting number". Adjust the smart value formula to this: