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

------------------------------
Chelsea Carpenter
------------------------------