Do not put the code in the input validation object

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject:

Hi,

You state you have placed the @DBLookup formula in the Input Validation object of the shared field. But an input validation formula should always end with a call to @Success or @Failure.

I think you want your formula in the Input translation object. Or even better, since the value of the field looks like it is depending on the value of another field, make the field Computed, with the dblookup formula as value.

Also, always build an @iserror routine around a dblookup. This prevents that you get an error if nothing is found. And there is no need to perform the dblookup if DBCPetsList is empty.

@if(DBCPetsList="";@return("");"");
food:=@DbLookup ("" : "NoCache" ; "" : Mammals_SR_Courses.nsf; "PetInfo" ; DBCPetsList; 2; "");
@if(@iserror(food);"";food)

Regards,
René

Feedback response number WEBB8Z4HPS created by ~John Elluly on 10/15/2012