How to create lookup table based on custom fields?

[Ken Klawiter]

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

[Alexey Matveev]

Hello,

As far as I understand you want to create a custom field, which would be incremented on some event. If so, then it is not possible out of the box. You need an add-on.

[Ken Klawiter]

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

[Alexey Matveev]

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

[Ken Klawiter]

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