I have the following field validation to check for numbers only:
@If(@IsError(@TextToNumber(@Text(@ThisValue)));@Failure(“Numbers Only!”);@Success);
The field being tested is a number field. The field validation works fine in a client but not on the web. It throws a 500 error on the web. Any idea of how to check for numbers only on the web?
If I change the field to text then it works fine but I would really rather it be numeric.
Subject: Number only field validation works fine in client but not on web?
This occurs with Dates as well. It seems that Domino will try to store the data in the fields without validating it for the trip to the server where it will then process your validation routines. This of course triggers the standard Notes error about invalid data for datatype.
Your best bet is to use Javascript to validate the field.
if isNaN(document.forms[0].fieldName.value){
alert(“some message”);
return false;
}
This would normally be used as part of a validation routine called at document submit.
Edit:
For the record, its still that way in Notes 8.0.1