Parameters: Field, TextFormula

This action sets the value of the Field according to the specified TextFormula.

Text Formula represents simple text that can include field values of a record, and variables.

In the script this action is displayed as: [Field] = Text Formula.

Examples of use:

• [Status] = Complete. (simple text)
• [Full Name] = Mr [First Name] [Last Name]. (merge two fields)
• [Name] = [Name^text UCASE]. (transform the text in the field to the upper case)
• [Date] = [$_date]. (set the field value according to the current date).

If a value of a field is changed with the help of this command, the "On Edit" script will not be called for the changed field. This script is called only if a field is edited manually.

You can call this script using the Execute field's script action.