User name lookup

HCL Domino Domino Forum
1

I am trying to do a lookup on the users in the addressbook and returning only Firstname and Lastname, no domain name. I tried doing a @dbcolumn on the ($Users) view, but I also received the OU entries. Is there a way to convert the users that you select in an names field so the field will only show Firstname and Lastname.

Thanks

-Brian-

2

Subject: User name lookup

Take a look at @Name in designer help -

Something like @Name([CN]; LkupValue)

3

Subject: RE: User name lookup

Thanks, you got me to think and this is what I used.

tmpServer := @ServerName;

tmpDatabase := “names.nsf”;

tmpView := “($People)”;

tmpColumn := 2;

tmpVal := @DbColumn(“”;tmpServer:tmpDatabase;tmpView;tmpColumn);

@If(

@IsError(tmpVal);

“- No values available -”;

tmpVal = “”;

“- No values available -”;

@Unique(@Name([CN]; tmpVal))

)