Hi there!
What kind of formula should I add to a numeric column type, that only be valid if a total of 10 numeric digits are enter?
Should i add this in valid if? [_THIS]>999999999
Perfect. Glad you figured out the problem.
Thanks! Text formula works perfect to
@Aparicio_Pineyrua1 Yes, if you are trying to validate the column value.
Many thanks!
And how about text values? How can I add somthing similar?
Maybe LEN([MyTextField])>9
Will try, many thanks again!
.
I must be confused about what you are trying to verify.
I thought you wanted to report an error is a number had fewer that 10 significant digits. If the number had leading zero digits those were not considered to be significant digits.
That is mathematically equivalent to verifying that the value of the number is greater than 999,999,999.
If my reading of your question was wrong, what are you trying to verify?
It was my mistake, if I need more than 8 digits I need to add seven โ9โ into the formula
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |