Forum Discussion

ChelseaCarpent1

Qrew Trainee

5 years ago

Is it possible?: Minimum Characters Restriction on Fields

I see where I can set a maximum number of characters restriction on a field. Is it possible to set a minimum restriction? ------------------------------ Chelsea Carpenter -------------...

Custom Data Rules

Formulas and functions

Qrew Member

How about a numeric field, what formula can be used then?

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

Huh?
What's the question. Can you say in words what rule you want to enforce.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

20494
Qrew Member
3 years ago
I know I can use the formula below to limit the digit of entry for a text field. But this formula doesn't apply to a numeric field.
Is there any way to limit the digit without changing my field type into a text field?
Thank you!

IF(
Length([My Text field])> 0
and
Length([My Text field]) < 5,
"You must enter at least 5 characters in the XYZ field")
- MarkShnier__You
  Qrew Legend
  3 years ago
  I don't mind trying to help you but you really do just need to try to say in plain English words what rule you are trying to enforce.
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
- MikeTamoush
  Qrew Commander
  3 years ago
  Assuming you mean the number of digits ('characters') in a numeric field (so 123 is 3 characters, 5555 is four characters), then use marks formula but wrap the field in totext().
  
  IF(
  Length(ToText([My Number field]))> 0
  and
  Length(ToText([My Number field])) < 5,
  "You must enter at least 5 digits in the XYZ field")
  
  ------------------------------
  Mike Tamoush
  ------------------------------
  - 20494
    Qrew Member
    3 years ago
    Yeah, that's perfect!
    
    Thank you very much Mike!