How to format the custom number field?

Question

Hey

i have created a custom field (number Field), in which I can only enter numbers, however it automatically adds a "." to the number when it exceeds 1k for example 1234 -> 1.234. I want to get rid of this ".", since it is not a real number value but more like an ID ( I do not want to use the custom text field, since it is not preventing others from entering something else than a number).

Im glad if someone can help me

Nic Brough -Adaptavist- · Answer

Sorry, I did not write that very clearly.

Your best option is to use a text field, but then you could do things like

* Write a validator that can block the progression of the issue until the content is formatted correctly
* Write an automation that can correct the formatting.  That might be easy if someone enters a simple mistake like 12e456, but you'll need to think of rules for correction that won't make a nonsense of the data - "removing all characters that are not 0-9" for example.
* Write an automation that messages someone to tell them an invalid string has been entered (email or chat maybe)

You could use any or all of those, or something on the same lines - prevent errors, notify the user, or notify another team member, etc.

Almighty Drake · Answer

Where can I set up such a validator or do you just mean some sort of automation which notifies me when someone put something wrong but actually still do not prevent the person from entering the field?

Nic Brough -Adaptavist- · Answer

Hi,

You can not do this.  Numeric fields are for numbers and are formatted according to your language settings.  You are always going to find them using a separator (and decimal points if you happen to enter fractionals)

I'm afraid your best option is use a text field, and then automate something - either a validator to say "you can not progress this issue until the field is correct" or something that detects when the field is changed and either reports the incorrect usage to the user/admin/team-lead or corrects it.