Here is the issue I am trying to solve for.
Our team uses the "Component" field to represent a master project number. Each master project number has 12 sub-project numbers under it however these are not populated in the "Component" field. Based on the "Component" and the custom field "Release" you could look up the value for the sub-project number from an outside system, but this doesn't meet the needs of the team. They would like that information directly in JIRA so that we have one source of truth. The idea is to have a new custom field called "Sub-Project Number."
I'm trying to figure out if we can update the "Sub-Project Number" based off the "Component" and "Release" field values. Due to the number of Components, Releases and Sub-Project Numbers and the fact it will be changing regularly I can't imagine hard scripting it, but think instead we would need some sort of lookup table so the table could be updated versus the script and then the script would go look at the table.
As a note, we have ScriptRunner which I am quite new to using which might be an option. We also have Confluence if that might be useful to house the table.
Any help to guide me to what my options are would be greatly appreciated.
