Working with @functions

All @functions evaluate to a value and can be placed in a formula anywhere a value of that type can be placed. When the formula executes, the value of the formula takes the place of the formula. Some formulas also have side-effects, that is, they cause actions to occur. For example, @Prompt causes a message box to appear.

Most @functions can be used in formulas for any Notes® object, but some @functions are restricted in their applicability. The following table lists the @functions that are restricted and lists the Notes® objects in which they can be used effectively. In addition, for an @function to return information on the current database, view, document, or field, these objects must be current.

Restricted function

Function only works in these Notes® objects

@All

Replication formula, agent, view selection formula

@AllChildren

Replication formula, view selection formula

@AllDescendants

Replication formula, view selection formula

@Command

Toolbar button, manual agent, action hotspot

@DbColumn (Domino® data source)

Toolbar button, action, hotspot, field design, agent except mail

@DbLookup (Domino® data source)

Toolbar button, action, hotspot, field design, agent except mail

@DeleteDocument

Agent

@DeleteField

Agent

@DocChildren

Column formula, window title formula

@DocDescendants

Column formula, window title formula

@DocLevel

Column formula, window title formula

@DocMark

Agent

@DocNumber

Column formula, window title formula

@DocParentNumber

Column formula, window title formula

@DocSiblings

Column formula, window title formula

@Failure

Field validation formula

ENVIRONMENT

All except formula pop-up hotspot

@Environment

All except formula pop-up hotspot when writing

FIELD

Toolbar button, agent, action hotspot, field design

@IsCategory

Column formula

@IsDocBeingLoaded

Form design, field design

@IsDocBeingMailed

Button, hotspot, field design

@IsDocBeingRecalculated

Button, hotspot, field design

@IsDocBeingSaved

Button, hotspot, field design

@IsExpandable

Column formula

@IsNewDoc

Toolbar button, window title formula, form design, field design

@MailSend

Toolbar button, agent, action hotspot

@PickList

Toolbar button, manual agent, action hotspot, field design

@Platform

Toolbar button, manual agent, hotspot, view design except selection and column formulas, form design, field design

@Prompt

Toolbar button, manual agent, action hotspot, field design

@Responses

Window title formula, field design

@Return

Toolbar button, agent, hotspot, field design

SELECT

Replication formula, agent, view selection formula

@SetDocField

Toolbar button, agent, action hotspot, field design

@SetEnvironment

All except formula pop-up hotspot

@SetField

Toolbar button, agent, action hotspot, field design

@Success

Validation formula

@Unavailable

Agent

@ViewTitle

Agent