How to create lookup table based on custom fields?

Question

First timer here, so please be patient.

I am migrating a manual workflow to Jira.  The current process has a project number followed by an incrementing value.  ex. 12345-000.  As project are added, the number will be incremented. ex. 12345-001, 12345-002...  There are currently about 15 projects, all with different incremental values.   ex. 23456-021, 34567-006...

Before going any further, an add-on is not the preferred option in this case.

My first thought was to setup a table that will hold the project number and the incrementing value.  When a new issue is created, search the table, and if the project number is there, increment the value and copy it to the issue.  If the value is not there, add it to the table, with a value of 000.

My question is can this be done, and what is the best approach to accomplish this?  I have looked at many other posts, and tried some things, but nothing solves this problem.

Thanks in advance for your suggestions and help.

Ken

Ken Klawiter · Answer

Alexey,

Thanks.  I looked at the cost of both add-ons, and feel the cost is not worth the lack of this functionality.   Maybe someone else can offer a solution.

Thanks,

Ken

Alexey Matveev · Answer

You could use the ScriptRunner or Power Scripts add-ons.

Ken Klawiter · Answer

Close.  It would be incremented as each new issue with the same project number would be created.

Is there an add-on that you would recommend?

Thanks,

Ken