Examples: @NameLookup

IBM Lotus Domino Designer 8.5
Versions 8.5 and 8.5.1

Examples: @NameLookup

You have three Domino Directories on your local environment, namely, Names_A.nsf, Names_B.nsf, and Names_C.nsf. Each Directory has the following entries:

	Names_A.nsf	Names_B.nsf	Names_C.nsf
View: ($Users)	Does not exist	Exists	Exists
User: Katsushi	User: Katsushi Item: Katsushi_A	User: Katsushi Item: Katsushi_B	User: Katsushi Item: Katsushi_C
User: Jones	User: Jones Item: Jones_A	User: Jones Item: Jones_B1 Item: Jones_B2	Does not exist
User: Smith	User: Smith Item: Smith_A	Does not exist	User: Smith Item: Smith_C
User: Yoshito	Does not exist	Does not exist	Does not exist

The following formulas return "Katsushi_B" : "Jones_B1" : "Smith_C" : ""

@NameLookup ( [NoUpdate]; "Katsushi":"Jones":"Smith": 

             "Yoshito"; "Item")

@NameLookup ( [ForceUpdate]; "Katsushi":"Jones":"Smith": 

           "Yoshito"; "Item")

The following formula returns "Katsushi_B" : "Jones_B1" :"" : ""

@NameLookup ( [NoSearching]; "Katsushi":"Jones":"Smith": 

           "Yoshito"; "Item")

The following formula returns "Katsushi_B" : "Katsushi_C" : "Jones_B1" : "Jones_B2" : "Smith_C"

@NameLookup ( [Exhaustive]; "Katsushi":"Jones":"Smith": 

           "Yoshito"; "Item")

If the current user is a software engineer, the following code, when added as the default value for a field, displays SOFTWARE ENGINEER.

@NameLookup([Exhaustive];@UserName;"JobTitle")

Related topics

@NameLookup

Library | Support | Terms of use |

Last updated: Monday, October 5, 2009