Domino Code Fragment

Code Name*
Keyword formula to lookup a value in a view and return to fields to the keyword list.
Date*
06/28/2025
Source (or email address if you prefer)*
[email protected]
IP address:.172.71.1.158
Description*
This formula reformats the user name as last name, comma, first name, taking care to handle hierarchical names. The formula looks up the reformatted user name in the Phone Numbers view of the current database and returns a list consisting of the values found in columns 2 and 3.
Type*
Formula
Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:
n := @Left(@UserName; "/");
k := @Right(n; " ") + ", " + @Left(n; " ");
@DbLookup(""; ""; "Phone Numbers"; k; 2) : @DbLookup(""; ""; "Phone Numbers"; k; 3)