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

[Vladimir Vladimirov]

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 · Accepted solution]

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{{/}}