nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to remove comma when getting value from a field with number type

Erdős Zoltán

The thing is: I have 2 customfields, first is a number type field, second is URL type field.

When a user modifys the number type customfield, I want to copy that value into an another customfield(which is the URL type field).

The URL field has a Prefix, and the end will be the value of the number type customfield that the user just typed into the number type field.

I succesfully solved this problem wih Automation, but when I getting the value of the modified customfield(number typed), it will put comma inside the numbers. Like: 1 -> 1.0

How can I replace those commas?

In My Automation rule, my "additional fields" JSON is:

{
"fields": {
"My URL Customfield": "https://someurl.com&id={{issue.customfield_10071}}"
}
}

I tried to use smart values - JSON functions but, it won't worked for customfields somehow...

Thank you for your help,

Zoltan Erdos

Accepted answers

Daniel Ebers

Hi @Erdős Zoltán

from the looks I solved the riddle - but please do an own test. Happy if you can confirm if it is what you were looking for.

I am just showing the difference to your JSON snippet, do let me know if you need further information:

{
"fields": {
"customfield_10082": "https://www.example.com&id={{customfield_10081.format("###")}}"
}
}

Cheers,
Daniel

All comments

Prince Nyeche - ELFAPP

Hi @Erdős Zoltán

The number field is translating to float value. I don't think you can convert that easily. so it's better you simply use text custom field rather than number field type. If you still want to use the number field, then you should look at the functions for maths expression, like rounds().

Erdős Zoltán

Thanks, I think maths expressions are not solve my problem here. (eliminate comma)

Okay, I can change it to Text Field, but I wanted that the user only can type numbers to this field, and with text field how it is possible?

I need to implement some triggers to the workflows?

Prince Nyeche - ELFAPP

I know script runner can do such which is an additional addon and cost. however ensuring the text field is of type numbers with validators with Jira's native feature I don't think that exist except what you can do is create a third field of text field type, copy the value from the number field type into the text field and use the text field in the url field.