how to make calculation between secure fields ?

Question

good morning, has anyone of you ever used the secure fields plugin, from coresoft labs, and can you tell me if it is possible to use them in script runner behavior to make a "calculation" between the values of these fields? Unfortunately these fields are not visible from automation for Jira.

Budget - Final Budget = Remaining Budget

(all three are secure custom fields)

when Budget changes (for example user modifying issue in Edit)
or Final Budget

Remaining Budget should report the subtraction update of the first two.

Lih Yao Tiong · Answer

Sure, just let me know if there's any update. :D

unknown · Answer

@Lih Yao Tiong

thanks for your help, the three fields are all secure custom fields, I will try anyway to follow your suggestions, and hopefully solve. I'm waiting for Atlassian to consider the opportunity to make custom fields "visible for everyone in the same way and from any plugin", so that I can comfortably work with cases like mine that are practically "the daily work" in any medium-large business context.

Lih Yao Tiong · Answer

Hi @[deleted],

If you do not mind that "Remaining Budget" is not a secure custom field. I would say that  ScriptRunner: Scripted Field might be the solution for you.

To calculate a number based on other fields, please refer to the document: https://scriptrunner.adaptavist.com/latest/jira/scripted-fields.html#_examples

I'm not using CoreSoft plug-ins, so I'm not sure if it works for ScriptRunner, but the Scripted field should work fine if there are Jira defaults custom fields.

I hope it helps :)