Number settings do not get saved

[LLD]

I need to save 2 types of unique account numbers for my employees, i.e. 

Provident Fund account number which is 12 digits long, and

Insurance number which is 10 digits long

For both, I choose -

• column data type as Number,
• Numeric digits as 12 (or 10),
• display mode as Auto
• deselect 1000s separator,
• set maximum value & minimum value as 999999999999 and 100000000000 respectively (for insurance this is 9999999999 and 1000000000 respectively),

but as soon as I save, and the page refreshes, all settings are missing and it looks like this...

pls help. I don't know what I'm doing wrong

[1minManager · Accepted solution]

Hmm no idea what that might be.  But as an alternative consider using this for the valid if equation:

LEN([ColumnName])=12

Simon@1minManager.com

[LLD]

Thank you Simon @1minManager . I have used this solution before, but I was hoping there was something a bit more basic in the field settings... thank you very much!

[1minManager]

Having thought about this a bit more.  The issue with using a number column is that for a 12 digit number 000012345678 would not be allowed or at the very least be changed to 12345678.  If you need leading zeros then the column type will have to be TEXT