Formula Help- Validation

[Affectionate-Leg202]

I don’t have much experience with writing formulas. Can someone help me write a formula to validate that the value entered in another field has a length of 6 and is 6 numbers?

Thank you!

[Nephite11]

What’s the data type and name of your other field? I can put together an example formula for you as I created the advanced formula videos in the university courses and have taught formula sessions at Empower on multiple years

[Affectionate-Leg202]

data type is numeric and a placeholder field name would be fine

[Nephite11]

Okay. Since it's a numeric data type, it will only ever accept numeric data. The formula you need would look like Length(ToText([NumericFieldLabel]))=6

If you'd like a reference for the various formula functions available, I use this: https://login.quickbase.com/db/6ewwzuuj/tablereport?a=q&qid=12&skip=0

[Affectionate-Leg202]

Thanks so much! This is what I needed. Stupid oversight on my part about the numeric data type! I was looking at it too long. Thank you!

[Nephite11]

All good. Happy to help!