Copy data from time tracking field to custom field using automation

[Filip Novák]

Hello all, 

I need to solve an issue, where we are using the time tracking in Jira and I need to copy the data from the "Original estimation" filed to my custom field with every change and with every new creation. 

My custom field has to be the number.

I used the Jira automation, but Jira is giving me information, that Jira was not able to convert the field value into the number.

Here is the formula I am trying to use: 

{
"fields": {
"Sledování času [TEST2]": "{{timetracking.originalEstimate}}"
}
}

Thank you for any help. 

[Vamsi Kandala · Accepted solution]

Hi @Filip Novák

Welcome to the Atlassian community!

Can you try replacing 'Sledování času [TEST2]' with the custom field id like 'customfield_xxxxx'?

Also, can you provide the screenshot of how you have setup the automation rule and what is the actual error if any?

Thanks,
Vamsi

[Filip Novák]

Hello @Vamsi Kandala , 

I did replace it. 

Here is the issue:

[Vamsi Kandala]

Hi @Filip Novák

Thank you for providing the screenshots.

The original estimate value is measured in milliseconds.  So, you can choose to convert the value accordingly depending on whether you want the value to be in minutes or hours etc.

{{timetracking.originalEstimate / 60,000}} should give you the value in minutes.  Can you try this?

Regards,
Vamsi

[Filip Novák]

@Vamsi Kandala Now I am receiving success message, but the value of the custom field remain NULL.

Can you help me to solve this? 

Thank you, 
Filip

[Vamsi Kandala]

Hi @Filip Novák

Hmmm...sorry that it not work out.

Let me check for some other solution.

Thanks,
Vamsi

[Filip Novák]

@Vamsi Kandala Thank you. Let me know if you find something.

[Filip Novák]

@Vamsi Kandala the solution was: 
{{issue.Original estimate}}/60
Or if we wanted hours format /3600 instead. 

[tatevikalaverdyan]

Hello Filip,

I tried this solution, but get this kin of error. Can you help me?

Error editing issues

AL-8760 (No unit for '/3600' (customfield_21623))

My Automation is this:

{
"fields": {
"Initial Remaining": "{{issue.Remaining estimate}}/3600"
}
}