We have a field which has a minimum investment amount of $10,000.  Can anyone provide me with guidance as to what is the most appropriate regular expression to use within the validation rule?

  1. Glenn Crook

    Ben's answer below covers how to do a simple min/max value validation, regular expressions are mainly used for pattern matching, eg email, phone number, social security number, tax file number, etc.

CommentAdd your comment...

1 answer


    Hey Brooke,

    I would not use an regular expression for this. You can add a simple Validation Rule that will quickly achieve what you want.

    For example the following validation rule:

    produces the desired result:

    1. Unknown User (brooke.mcneil@ampcapital.com)

      Perfect - thank you Ben (and apologies for such a simple query)

    CommentAdd your comment...