Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Set field value (text)

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Set field value (text)

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.

All topics in the "Fields Operations" section: