Domino Code Fragment

Code Name*
Keyword formula to lookup a value in a view and return to fields to the keyword list.
Date*
04/28/2024
Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.3.17.184.90
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)