Print      Open PDF Version of Online Help


Previous Topic

Next Topic

PRE Function

The PRE function in Expression Builder returns the previous value of the specified field when the field value is modified and before the value is updated in the database.

Syntax

PRE('<fieldname>')

Result Type

String

Arguments

The following table describes the arguments for the function.

Argument

Description

fieldname

The name of the field that was modified.

Examples

Example 1: To prevent a field value from being updated, create a workflow with the following condition:

PRE('<FieldName>') <> [<FieldName>])

and the following UpdateValue action (to set the field back to its original value):

Field Name = PRE('<FieldName>')

Example 2: To test a modified field that was initially null, use the following expression:

[<FieldName>] <> IfNull(PRE('<FieldName>'), "Invalid"))

Related Information

See the following topics for related Expression Builder information:


Published May 2008