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 |
|---|---|
| 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 |