Hi there! What kind of formula should I add ...

(Aparicio Piñeyrúa) #1

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?

(Philip Garrett) #2


If there are no leading zeroes you could use


(Aparicio Piñeyrúa) #3


Should i add this in valid if? [_THIS]>999999999

(Philip Garrett) #4


Perfect. Glad you figured out the problem.

(Aparicio Piñeyrúa) #5


Thanks! Text formula works perfect to

(Philip Garrett) #6

@Aparicio_Pineyrua1 Yes, if you are trying to validate the column value.

(Aparicio Piñeyrúa) #7


Many thanks!

(Aparicio Piñeyrúa) #8


And how about text values? How can I add somthing similar?

(Philip Garrett) #9


Maybe LEN([MyTextField])>9

(Aparicio Piñeyrúa) #10


Will try, many thanks again!

(Aparicio Piñeyrúa) #11


(Philip Garrett) #12


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?

(Aparicio Piñeyrúa) #13


It was my mistake, if I need more than 8 digits I need to add seven “9” into the formula