APPLICATION DESIGN


Formulas that look for values in columns and views
Lookup formulas are useful in choice list field formulas to search for values in another database or in the same database.

Referring to views in @function formulas

To refer to a view in an @function formula such as an @DbColumn or @DbLookup, use the actual view name or an alias, in quotes, or use the full cascading name, with an additional backslash (\) so that IBM® Lotus® Notes® can interpret the cascading name. For example:

"By Author"

"View1"

"By Author\\Last Name"

Referring to columns in formulas

To refer to a column in an @DbColumn or @DbLookup formula, use the column number, rather than its title. Columns are numbered from left to right: the leftmost column is column number 1. Refresh the view to make sure you see all its columns.

Some columns are not counted in a search, so skip them when you're counting column numbers:


If you plan to use a lookup formula, such as @DbColumn or @DbLookup, to retrieve data from a view, include a sorted column that the formula can use as the lookup key.

Caution If the column used as the lookup key can be resorted by clicking on the header, the formula will return unpredictable results, depending on the current sort.