HCL Domino - Examples: Input validation formulas - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

PROGRAMMING OVERVIEW AND USER INTERFACE

Examples: Input validation formulas
1. This input validation formula doesn't let the Cost field exceed 100.

@If(Cost<100; @Success; @Failure("Cost must be less than $100"))

2. This formula forces the user to enter a ten-digit number. The formula removes up to two hyphens if they are present. The formula converts the result to a number and returns a failure if an error occurs on the conversion. The formula converts the number back to text and checks its length, returning a failure if the length is incorrect. This last step is necessary because @TextToNumber successfully converts, for example, 123A to 123.

N1:= @If(@Contains(Home_Phone; "-"); @Left(Home_Phone; "-")+ @Right(Home_Phone; "-"); Home_Phone); N2:= @If(@Contains(N1; "-"); @Left(N1; "-")+@Right(N1; "-"); N1); N := @TextToNumber(N2); @If(@IsError(N);@Return(@Failure("Home phone must be zip-xxx-xxxx.")); @Success); @If(@Length(@Text(N))!= 10;@Failure("Home phone must be zip-xxx-xxxx."); @Success)

See Also

Input validation formulas

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Feedback on Help or Usability?

Help on Help

All Help Contents