![]() |
|
![]() |
PRE FunctionThe 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. SyntaxPRE('<fieldname>') Result TypeString ArgumentsThe following table describes the arguments for the function.
ExamplesExample 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 InformationSee the following topics for related Expression Builder information: | ||||||
Published May 2008 |