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
------------------------------
20494's avatar
20494
Qrew Member
3 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
    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's avatar
      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew 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
        ------------------------------