Home
HCL Domino Designer Basic User Guide and Reference
Basic product usage information and programming language reference information.
Programming Overview and User Interface
This section contains general guidelines and examples that show where to use Java, LotusScript, and the formula language.
Programming Overview
This documentation describes how to attach Java, JavaScript, LotusScript, and formula code to Domino design elements. Here are some overview topics:
Field design formulas
As part of the field design process, you can write the following formulas to run on the user's workstation:
Keyword field formulas
A keyword field presents the user with a list of keywords for entry into the field. The list can be the result of a formula or a list of constants.
Examples: Keyword field formulas

Examples: Keyword field formulas

This formula uses as a keyword list the values in column 1 of the Names view in the current database.
```
@DbColumn(""; ""; "Names"; 1)
```
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.
```
n := @Left(@V3UserName; "/");
k := @Right(n; " ") + ", " + @Left(n; " ");
@DbLookup(""; ""; "Phone Numbers"; k; 2) : @DbLookup(""; ""; "Phone Numbers"; k; 3)
```