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 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

Accepted answers

Pramodh M

@Calderara Serge

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

Thanks,

Pramodh

All comments

Pramodh M

@Calderara Serge

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

Thanks,

Pramodh

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)

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 🙂

Pramodh M

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira-software

jira-software-server