At least 10 numbers

F

follower

I'd like to know how to make a rule that says that the user needs to put in
at least 10 numbers (like the number of digits in a US phone number). Does
this require an expression and if so, what are the steps and details needs to
get the expression setup up?

Thank you.
 
C

Clay Fox

In data validation or with rules add a condition and there is a comparison
option for "matches pattern" in the dropdown.
Then you can pick from one of the included patterns or create your own.
Phone number is there but you can create your own custom pattern.
 
F

follower

If you use a Data Validation approach with the 'matches pattern' option, that
is restricting the person to enter the numbers in a particular way (which
I've tried already).

Without asking the user to enter the numbers in a particular way, could it
be done another way?
 
C

Clay Fox

You would just add a rule to the field that after input or change to the
field it would check the condition and if it did not match the pattern could
either format it for the user using a sub string or pop a message or whatever
you wanted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top