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 |
Replication formula, agent, view selection formula |
|
Replication formula, view selection formula |
|
Replication formula, view selection formula |
|
Toolbar button, manual agent, action hotspot |
|
Toolbar button, action, hotspot, field design, agent except mail |
|
Toolbar button, action, hotspot, field design, agent except mail |
|
Agent |
|
Agent |
|
Column formula, window title formula |
|
Column formula, window title formula |
|
Column formula, window title formula |
|
Agent |
|
Column formula, window title formula |
|
Column formula, window title formula |
|
Column formula, window title formula |
|
Field validation formula |
|
All except formula pop-up hotspot |
|
All except formula pop-up hotspot when writing |
|
Toolbar button, agent, action hotspot, field design |
|
Column formula |
|
Form design, field design |
|
Button, hotspot, field design |
|
Button, hotspot, field design |
|
Button, hotspot, field design |
|
Column formula |
|
Toolbar button, window title formula, form design, field design |
|
Toolbar button, agent, action hotspot |
|
Toolbar button, manual agent, action hotspot, field design |
|
Toolbar button, manual agent, hotspot, view design except selection and column formulas, form design, field design |
|
Toolbar button, manual agent, action hotspot, field design |
|
Window title formula, field design |
|
Toolbar button, agent, hotspot, field design |
|
Replication formula, agent, view selection formula |
|
Toolbar button, agent, action hotspot, field design |
|
All except formula pop-up hotspot |
|
Toolbar button, agent, action hotspot, field design |
|
Validation formula |
|
Agent |
|
Agent |