Forum Discussion

ChelseaCarpent1's avatar
ChelseaCarpent1
Qrew Trainee
6 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago

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
------------------------------
  • ChelseaCarpent1's avatar
    ChelseaCarpent1
    Qrew Trainee
    6 years ago
    Worked like a charm, thank you!

    ------------------------------
    Chelsea Carpenter
    ------------------------------
  • 20494's avatar
    20494
    Qrew Member
    4 years ago
    How about a numeric field, what formula can be used then?
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 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's avatar
        20494
        Qrew Member
        4 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")