The only relation currently permitted is the foreign key relation.
$FK(<foreign key column>).<column name>:<data type>$
An Active Directory user’s first name should based on the assigned employee. The template for ADSAccount.Givenname is:
Value = $FK(UID_Person).Firstname$
Optional process step parameters are not generated if the value is set to Nothing or not assigned in the value template. This makes it possible to limit the number of parameters for target system components. If such a value should be cleared, an empty string should be transferred instead of Nothing.
A value template may look like this:
If $Lastname[o]$ <> $Lastname$ Then
Value = $Lastname$
NOTE: For some standard columns such as XDateInserted, XDateUpdated, XUserInserted, XUserUpdated, XOrigin, XIsInEffect and XMarkedForDeletion , the new values are only determined after saving the object. This means that when processing the templates, the new column value is always the same as the old value (e.g. $XDateUpdated[o]$ = $XDateUpdated$).
When a display value for a column is created, the properties Multilingual (IsMultiLanguage) and List of permitted values (LimitedValues) are resolved.
A list of permitted values is defined for the restriction type of the IBM Notes server restrictions.
PrivateList=Run Personal Agent RestrictedList=Run Restricted Agent UnrestrictedList=Run Unrestricted Agent
If a server restriction has the value PrivateList, the value Run Personal Agent is displayed on the information form.
The display value for the server restriction should be formatted from the name of the IBM Notes user and the display value of the restriction type.
Value = vid_Left($FK(UID_NotesUser).FullName1st$,39) & " [" & vid_Left($NotesAgentMgrType[D]$, 22) & "]"
The preprocessor also interprets references that are embedded in comments, for example, $Lastname$. Referencing a column in a script comment results in the script being run when the column value is changed.
An employee’s starting date is filled with a template. This template should run when the employee’s surname changes. The template for Person.Entrydate is therefore:
Value = Date