Domino Code Fragment

Code Name*
Validate The Number of Digits in a Field		Date*
04/28/2024		Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.3.138.122.4
Description*
If you have a field (in this case called partNumber) which should contain a value (such as a part number) which must be of a particular length, then use this type of formula in the validation formula to check the field to make sure the correct number of digits has been entered.		Type*
Formula		Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
If you want to add the condition that the first digit does not equal a particular value, for example X, then modify the formula to read: msgNotSix := "Part number must be 6 characters in length"; msgX := "Part number must not begin with an X"; @If (@Length(PartNumber) != 6; @Failure(msgNotSix); @Begins(PartNumber; "X"); @Failure(msgTwo); @Success
Files/Graphics attachments (if applicable): Code:
failMsg ="Part number must be 6 characters in length";
@If (@Length (partNumber) = 6; @Success; @Failure (failMsg)