Numeric Field -- Zero's

HCL Domino Domino Forum
1

I have a CustNo field that is numeric and I need to do an input validation on it to ensure that it is 10 digits. I am having a problem with the field dropping the zero’s. i.e, let’s say the CustNo is 0000001211 and I run the input validation with the following formula:

@If(@Length(@Text(CustNo))!= 10;@Failure(“Customer Number must be ten digits”); @Success)

It will give me the error that the CustNo is not 10 digits. When the document get’s saving it reads 1211.

Does anyone have any suggestion on how to keep the Zeros and still be able to conduct the validation on the number field?

Thanks ahead of time for your input.

2

Subject: You will have to make it a Text field not a Number field.

3

Subject: RE: You will have to make it a Text field not a Number field.

Thank you everyone for your valuable input! It worked to change it to text and it is not a key so that won’t be an issue. Again, thank you very much.

4

Subject: Numeric Field – Zero’s

… and if you are using this as a key field you should carefully review your design to make sure it is working properly as a text field vs a numeric field.

The change could trigger failures in sorts and other formulas where it is referenced.

5

Subject: Bill’s correct. Change to a text field and it’ll work as you want.