How to summarize custom fields values and put the sum into "Original estimate" ?

Question

Hi!

I've created Custom Fileds

"Backend estimate" with the "Number" field type

"Backend estimate time period" with the "Select List (single choice)" field type

Also, I've created Custom Fileds

"Frontend estimate" with the "Number" field type

"Frontend estimate time period" with the "Select List (single choice)" field type

What is the best way to summarize the values and put the sum into "Original Estimate"
For instance, Backend ( 8 h ) + Frontend ( 8 h ) = Original Estimate ( 2 d )

Is it possible to do it using ScriptRunner Add-On?

Thank you in advance!

Vladimir Vladimirov_4pqn0b · Accepted Answer

Hi!

I've achieved my goal using Automation

We've decided not to use minutes and days. Only hours.

A trigger is  "Update Issue Field": Backend estimate, Frontend estimate

An action is "Update Issue Field": Original estimate

4h + 6h = 1d 2h

{{#=}}{{issue."Backend estimate"|0}}*60+{{issue."Frontend estimate"|0}}*60{{/}}