Can't get dblookup return value

HCL Domino Domino Forum
1

Having some trouble with the DBLOOKUP commandI’ve a field call “NAME” that allows users to enter their Notes or Non Notes user name.

So I’m trying to write an agent to send mail notifications to the users who has Notes account and bypass the ones without notes user account. This is what

temp := @DbLookup( “” : “NoCache” ; “servername” : “database” ; “view” ; name ); columnnumber);

I don’t know if my statement is correct… but I just can’t get the return value. Any help would be thankful

2

Subject: Can’t get dblookup return value

Try this:temp := @DbLookUp (“”; Server:DBName; “view”; Name; “NAMEOFFIELD”)

Where NAMEOFFIELD is the name of the field containing the user’s email address. It’s better to put the name of the field. So if the view changes, and any column is inserted, the formula won’t be affected.