I need to crate validation for a single line of text column. The validation required is to count the total number of characters( Text and Numbers) entered amd validate that 7 items were entered.
When someone enters in their ID take "JN76161" for example I want the column to validate that they entered a total of 7 characters. No more no less.
If we can also validate so that it requires that the first two characters are text that would be awesome too.