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
MikeTamoush's avatar
MikeTamoush
Qrew Elite
3 years ago
Assuming you mean the number of digits ('characters') in a numeric field (so 123 is 3 characters, 5555 is four characters), then use marks formula but wrap the field in totext().

IF(
Length(ToText([My Number field]))> 0
and
Length(ToText([My Number field])) < 5,
"You must enter at least 5 digits in the XYZ field")

------------------------------
Mike Tamoush
------------------------------
20494's avatar
20494
Qrew Member
3 years ago
Yeah, that's perfect!

Thank you very much Mike!