Is it possible?: Minimum Characters Restriction on Fields

Question

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

chelseacarpent1 · Answer

Worked like a charm, thank you!------------------------------Chelsea Carpenter------------------------------

markshnier__you · Answer

Yes, but not there.&nbsp;
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])&gt; 0andLength([My Text field]) &lt; 5,"You must enter at least 5 characters in the XYZ field")this formula would permit blank.&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

20494 · Answer

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

markshnier__you · Answer

Huh?What's the question.&nbsp; Can you say in words what rule you want to enforce.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

20494 · Answer

I know I can use the formula below to limit the digit of entry for a text field.&nbsp; 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])&gt; 0andLength([My Text field]) &lt; 5,"You must enter at least 5 characters in the XYZ field")

Forum Discussion

Is it possible?: Minimum Characters Restriction on Fields