Managing Input Validation Options
MYOB Acumatica provides a range of tools to control the format of passwords, user and object names, phone numbers, email addresses, and postal codes that are entered in the system. You can use input masks to implement restrictions to allow particular types of characters in certain positions of these entities. Also, you can use regular expressions to define specific requirements for text strings entered by a user.
Input Masks
You create input masks by using the following symbols:
- C: Designates any character
- A: Designates any letter or digit
- L: Designates a letter only
- #: Designates a digit only
- ?: Designates an optional letter
- 9: Designates an optional digit
You can also use the following control symbols (which are not placeholders) to affect the characters that follow them:
- >: Requires that all letters that follow > are uppercase letters. If a lowercase letter is typed, the system will automatically convert it to uppercase. Subsequent > symbols will toggle the uppercase functionality. For example, the mask >LL>LL>LL will cause the uppercase to be turned off for the second LL characters, but then turned back on for the third LL characters.
- <: Requires that all letters that follow < are lowercase letters. If an uppercase letter is typed, the system converts it to lowercase. Subsequent < characters will toggle the lowercase functionality. For example, the mask <LL<LL<LL will cause the lowercase to be turned off for the second LL characters, but then turned back on the third LL characters.
- \: Causes the next character to be displayed literally (as it is).
- "": Causes the characters within the quotation marks to be displayed literally.
Regular Expressions
You can use standard syntax for regular expressions in MYOB Acumatica. For more information on regular expressions, see the Microsoft Software Developer Network.