developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


DBLookup - Matching usernames
Nana Yildizian 06/12/2018 09:00 AM
Domino Designer All Releases All Platforms

I have a login form where users log in with a username and a password. Upon login (authenticated), they should be able to change their preferences.
I am having problems with the dblookup where I'm trying to match the username the user is entering with the list of usernames in my view (instead of the result, the username, I'm getting error). What is wrong with my code/logic?
Any help will be much appreciated. Thanks in advance.
The code in the text-computed for display field is:

_loggedUser: =User_name; // User_name is the value of another field, the field where the user enters its username.

_res:=@DbLookup("":""; "":""; "Select Users By FullName";_loggedUser;1);
@If(@IsError(_res); "Error"; _res)

Go back