EVALUATED_FIELD_VALUE
Description
Returns the evaluated value of a mapped target field that has already been processed prior to the current field’s evaluation within the Executable’s Mapping step. If the field has not yet been evaluated, the function returns NULL.
Syntax
EVALUATED_FIELD_VALUE(mapped_target_field_name) -> Object
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| mapped_target_field_name | String | Yes | The API name of the target field that identifies which mapped target field’s evaluated value should be returned by the function. |
Example
TotalPrice is calculated first, then uses that value in Description.
Tips
- Use the Seq No. on the Field Mappings in the Executable’s related list to control the sequential order of field evaluation—otherwise, the evaluation sequence of field mappings is random.
- If multiple source records match the same target record, use this function to reference values from the prior iteration of field evaluation and apply your desired logic—otherwise the last iteration will override the previously assigned values.