How to format a number field with formatted value

[Calderara Serge]

Dear all,

I have a list of sub-stask which have a budget field value which is an Integer.

User are able to enter in this field freely number with different uncontrol format like :

Budget : 1234,5
Budget : 1234.5
Budget : 1'234,5
Budget : 1'234.5

What is the way to format correctly this field based on a standard number format for all users ?

The idea is that when all sub-task gets complete, I need to SUM all budget of all task and place the result in a calculated field. 

For that reason all number should be in same format

What is the best way to make this conversion format ?

regards

[Pramodh M · Accepted solution]

@Calderara Serge 

Use the number type custom field which only allows you to enter only the numbers

Thanks,

Pramodh

[Calderara Serge]

thanks

[Nic Brough -Adaptavist-]

Er, number fields allow decimals, that's the whole point of the question.

[Pramodh M]

Seems like @Calderara Serge is okay with the approach 🙂

[Nic Brough -Adaptavist-]

There's a number of things you could do here with Scriptrunner:

• Create a validator that tells people not to have fractions when creating or transitioning the issues
• Have a listener that picks up create and edit, reads the current value and rounds it
• Have a Behaviour fix the input (I'm not sure this can be done though, I don't use Behaviours a lot)

[Pramodh M]

We don't want to bring more complex configuration on how user enters the data while creating the issue! Correct?