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

[Aparicio_Pineyr]

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?

[Phil]

@Aparicio_Pineyrua1

If there are no leading zeroes you could use

[n]>999999999

[Aparicio_Pineyr]

@Philip_Garrett_Appsh

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

[Phil]

@Aparicio_Pineyrua1

Perfect. Glad you figured out the problem.

[Aparicio_Pineyr]

@Philip_Garrett_Appsh

Thanks! Text formula works perfect to

[Phil]

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

[Aparicio_Pineyr]

@Philip_Garrett_Appsh

Many thanks!

[Aparicio_Pineyr]

@Aparicio_Pineyrua1

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

[Phil]

@Aparicio_Pineyrua1

Maybe LEN([MyTextField])>9

[Aparicio_Pineyr]

@Philip_Garrett_Appsh

Will try, many thanks again!

[Aparicio_Pineyr]

.

[Phil]

@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_Pineyr]

@Philip_Garrett_Appsh

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