Forum Discussion

ChelseaCarpent1's avatar
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

8 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 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
      5 years ago
      Worked like a charm, thank you!

      ------------------------------
      Chelsea Carpenter
      ------------------------------
    • 20494's avatar
      20494
      Qrew Member
      2 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
        2 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
        ------------------------------