Custom Field - Rules

Rules can be applied to certain types of Custom Fields to enforce rules on the data recorded in these fields.

Date Fields

Rule	Definition
Min	The minimum date the field will accept. E.g. If the date is set to 01/01/2024 no date before 01/01/2024 can be recorded in the date field.
Max	The Maximum Date the field will accept. E.g If the date is set to 02/02/2024, no date after 02/02/24 can be recorded in the date field.

String, Unique Reference & Text Fields

Rule	Definition
Pattern	The pattern rule is in regards to regex patterns.  Regex (regular expressions) are character sequences defining search patterns in text, using symbols like . (any character) or * (repetition), aiding text search and validation. Should only be used if there's a core understanding of regex pattern .
Min Length	The Minimum length of characters the field will accept. E.g If the value is set to 5,  the field will not accept a value below this.
Max Length	The maximum length of characters the field will accept. E.g If the value is set to 5, the field will not accept a value above this.
Starts With	The field requires the value entered to start with a specific character/phrase. E.g If the required characters to start is 'TH',   it will not accept a value that doesn't start with the character/ phrase.
Ends With	The field requires that the value entered to end with a specific character/phrase. E.g If the required characters to end is 'You', it will not accept a value that doesnt end with the character/phrase.
Contains	The field requires that the value entered contain a specific character/phrase. E.g If the required character 'Z' isn't entered, the field will not accept the value.

Integer Fields

Rule	Definition
Min	The minimum numerical value the field will accept. E.g If the integer is set to a value of 10, no values under 10 can be recorded in the integer field.
Max	The maximum numerical value the field will accept. E.g. If the integer is set to a value of 10, no values over 10 can be recorded in the integer field.