Numeric validation

HCL Domino Domino Forum
1

Hi All,I have written a validation to accept Numeric characters only.But its giving me error Field can’t pass a validation Formula.Can anyone suggest whats the problem is?

@If(@Matches(@ThisValue;“+{!0-9}”); @Failure(“Use numbers only message here”); @Length(@ThisValue)<>10; @Failure(“Length message here”); @Success)

2

Subject: Suggestions

Did you search?http://www-10.lotus.com/ldd/nd6forum.nsf/Search?SearchView&Query=number%20and%20validation&SearchOrder=0&Start=1&Count=100

Break it down into smaller bits; try one specific validation, get that working, then do another. That makes debugging easier.

3

Subject: RE: Suggestions

Hi,I tried the same using lotus script.But dont know y my code is not working,not giving any error as well.I have written the below code to check the numeric validation.Any character others than number are entered it should prompt error.Can ayone suggest what could be the problem?

If Source.FieldGetText(“Cod”) Like “[a-z,A-Z]” Then

                    Msgbox "Code cannot be text .Please enter a numerical character" 

                    Call source.GotoField("Cod") 

                    continue=False 

            End If
4

Subject: RE: Suggestions

Whu not just use IsNumeric() to check if the field value is numeric?