Eval Macro

Use the Eval macro to evaluate an expression using the Custom Field Calculation syntax.

Parameters:

 

Expression:The expression to be evaluated. This expression can contain references to the fields in the current loan (using the square-bracket notation) or employ any of the functions available for use with custom field calculations.

 

 

Return Value:

 

The result of the expression. This value may be numeric, string, or Boolean depending on the expression being evaluated.

 

Example 1:

 

The following example uses two macros, SetField and Eval, to create an event that saves 2% of the loan amount in a custom field.

 

Macro.SetField("CX.Profit", Macro.Eval("0.02 * [1109]"))

 

Example 2:

This example code displays the full address of the subject property.

 

Dim Addr as String = Macro.Eval("[11] & "", "" & [12] & "", "" & [14] & "" "" & [15]")

 

Macro.Alert("Property is located at " & Addr)