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 -
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
Solved! Go to 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
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
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!
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
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |