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

@Aparicio_Pineyrua1

If there are no leading zeroes you could use

[n]>999999999

(Aparicio Piñeyrúa) #3

@Philip_Garrett_Appsh

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

(Philip Garrett) #4

@Aparicio_Pineyrua1

Perfect. Glad you figured out the problem.

(Aparicio Piñeyrúa) #5

@Philip_Garrett_Appsh

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

@Philip_Garrett_Appsh

Many thanks!

(Aparicio Piñeyrúa) #8

@Aparicio_Pineyrua1

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

(Philip Garrett) #9

@Aparicio_Pineyrua1

Maybe LEN([MyTextField])>9

(Aparicio Piñeyrúa) #10

@Philip_Garrett_Appsh

Will try, many thanks again!

(Aparicio Piñeyrúa) #11

.

(Philip Garrett) #12

@Aparicio_Pineyrua1

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

@Philip_Garrett_Appsh

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