Please tell me, I can remove the comma automatically inserted in the numeric custom field in Jira. I am using OnDemand and am therefore unable to use some of the obvious solutions found on the net
Hi, just checking in to see any progress as we face the same issue, the number showing in 5,555 for 4-digit with comma; wonder any solution not to use 1000 separator ?
The number we need is created during data migration, and somehow it cannot be searched in right top corner, either.
oh, even though that is driven by 1000 separator ? :-) I see your point, if we use number for currency, that is perfect, thousand, million
thank you for sharing your thought, Nic.
Thank you though, and I also got some feedback regarding quick search, I was told that no way to conduct number quick search, with ',' or without :-) (not by query line)
How is this the accepted answer? I need to suppress commas, regardless of what anyone says and the logic behind their argument. I can do this with every piece of software I use -- except for this one. Do I need to open a new thread since 'cannot be done' seems to be the order of the day on this one?
For the record, it's not what we have to say here. It is how we say it. Some of you could use a lesson in this little thing called TACT. Of course, now that I have descended into the muck, I'm going to Linkedin Learning now to find that class myself.
@Nic Brough [Adaptavist] "most humans prefer to see the separators! So, it's not changed."
What a narrow minded comment. What about numbers that don't have commas, such as product numbers, account numbers and the sort. Having commas changes the functionality of that number.
No, you're falling into a very narrow mindedview yourself there.
Think about it - product numbers, account numbers and other identifiers like that are not numbers, they are strings that happen to be constrained to numbers. If my bank account "number" was ABGORB32 it wouldn't be any better or worse than 71153622.
If you don't want separators in your fields, then use a text field. Separators are incredibly useful for humans when handling numbers, and I stand by "most humans prefer to see the separators", because it's inarguably correct.
@Nic_Brough__Adaptavist_ Every other software has a checkbox to enable/disable this option.... but Jira. Including Excel, arguably one of largest numbers software on the planet.
Bank accounts are ALWAYS numbers so no, they are not strings and no, they do not have commas separators.
Phone numbers are just numbers. SSN are just numbers, EIN numbers are numbers. Shall I go on? Do YOU want to think about it a bit more?!
Forcing a format that is not universally used is really bad practice.
Using a text field if you want an integer is a really bad practice:
The international consensus also shuns the comma or period:
"Numbers consisting of long sequences of digits can be made more readable by separating them into groups, preferably groups of three, separated by a small space. For this reason, ISO 31-0 specifies that such groups of digits should never be separated by a comma or point, as these are reserved for use as the decimal sign"
But yeah, after 3 years of browsing this forums, I would be genuinely surprised not to find Nic here telling people how outrageous and entitled it is to have requirements that exceed current offering...
The only alternative I have found is that you need to use a Text Field.
You may be able to add custom Triggers, Conditions and/or Validators to your flow for ensuring the number format is correct in your project's Workflow. Quite a bit of work for a simple number field but that's what I would do if you need a certain level of accuracy.
Can we all just agree that the number field should not have comma separators, and Jira should either add the comma as an option or create a currency field (hopefully one that supports more than just the western standard: $1,000,000.00.
Example currency format in France: 1 000 000,00€
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event