Is it possible to populate a comma to a number field automatically? To be able to separate the digits?
Number fields only hold raw numbers, but their display is determined by your language and region settings.
If I enter 1000000 into a numeric field, it displays as 1,000,000 for me, because English uses "," as the three digit separator. The field still only holds 1000000.
If your number fields are actually strings, then you'll need to edit them to add separators.
HI Narsha, there isn't specifics in your question regarding formatting, so I might be stretching a little. Out of the box, it looks like you can't format it directly, but with a little automation, it appears it can be done. I found this community article on formatting: Number-field-formatting
I hope that answers your question.
Hi Dan,
Sorry for this.
I created some custom field of type numeric. But, I want on the creation screen itself to be able to format this. For example, when entering a value like this '2152', it should appear like this: '2,152' or '2.152'.
From the article I assume they are using automation rule to format it? But in my case I want this to happen on the creation screen itself - while creating the issue, which I think is quite challenging to achieve on the creation screen.
Can you please help me on this?
Thanks.
Hi Nic,
I changed the region settings and it worked.
Thanks!
It looks like you're new here. Sign in or register to get started.
