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:

• Skip any columns that display a constant value.

  However, if a column contains a formula that happens to return the same result for every document (so that it appears to be a constant value even though it is not), the column does not display a constant value. Include the column in your column count.

• Skip any columns that consist solely of the following simple Notes functions or @functions:

  Collapse/Expand (+/-)

  # in View

  # of Responses (All Levels)

  # of Responses (1 Level)

  @DocChildren

  @DocDescendants

  @DocNumber

  @DocParentNumber

  @DocSiblings

  @IsCategory

  @IsExpandable

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.

Glossary