Format specification
Input masks use a simple syntax to describe a pattern:
| Character | Meaning |
|---|---|
| 0 | User must enter one digit (0 to 9) |
| L | User must enter a letter (A-Z) |
| A | User must enter a letter (A-Z) or a digit (0-9) |
| \0 | User must enter the digit 0 |
| \L | User must enter the letter L |
| \A | User must enter the letter A |
Any other character is assumed to be fixed.
Examples
| Example | Input mask | Explanation |
|---|---|---|
| Family registration number | 1-00000000 | All registration numbers start with “1-” followed by exactly 8 digits |
| Case worker initials | LLL | Exactly three letters |
| Case worker ID | 000 | Exactly three digits |
| Administrative number | 2\02\0-00-000 | Starts with “2020-” followed by a dash, followed by two digits, a dash, and three digits. |
| US Phone Number | (000) 000-0000 | Area code followed by 3 digits, a dash, and then exactly 4 digits. |
For more complex patterns, see the REGEXMATCH function, which can be used in validation rules.