Lotus Domino Designer 6.5 Help - Examples: @NameLookup

FORMULA LANGUAGE

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

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

@NameLookup ( [NOUPDATE]; "Katsushi":"Jones":"Smith": "Yoshito"; "Item")

@NameLookup ( [FORCEUPDATE]; "Katsushi":"Jones":"Smith": "Yoshito"; "Item")

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

@NameLookup ( [NOSEARCHING]; "Katsushi":"Jones":"Smith": "Yoshito"; "Item")

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

@NameLookup ( [EXHAUSTIVE]; "Katsushi":"Jones":"Smith": "Yoshito"; "Item")

4. 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")

See Also

@NameLookup

Glossary

Help on Help

Open Full Help Window

Glossary

Help on Help

Open Full Help Window