Forum Discussion

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

MarkShnier__You

Qrew Legend

Yes, but not there.

You can enable Custom Data Rules in the Advanced Properties of the table and enter a formula like this one

IF(
Length([My Text field])> 0
and
Length([My Text field]) < 5,
"You must enter at least 5 characters in the XYZ field")

this formula would permit blank.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

20494

Qrew Member

3 years ago

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

MarkShnier__You
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
    ------------------------------