Hello, how do I determine that a field can only have 8 numeric digits and make this mandatory? I know this can be done through mask, but I do not know how to use it
Solved! Go to Solution.
When usage says the function was used incorrectly.
LEN([numeric]) = 8.
If you put your formula
inside the valid if space, that will ensure that the length must be 8 characters long.
@doubts are you getting an error with that formula like that?
It may need to be:
LEN([numeric] & "") = 8
Hmm… you might be onto something - len is expecting a text:
LEN(TEXT([numeric])) = 8
Note that use of TEXT() will apply display formatting to the result, which may change the length. CONCATENATE() or &
will retain the stored format.
I didn’t know that about text(). Every day is a learning day.
There is also a setting for the number of digits for the Number type details:
It didn’t work for me.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |