Expressions

Introduction

Expressions allow you to add business logic to your data.

Creating a new expression

Follow these steps to create a new expression.

Step	Action
1	Go to the Data tab in your app development environment.
2	In the table list, click on the table in which you want to create an expression. The table items are displayed in the table item list.
3	Right click in the table item list and select New expression....

The Edit Expression Attribute dialog is displayed. See illustration below.

Below is a description of the elements of the Edit Expression Attribute dialog.

Element	Description
General properties	Contains basic information about the expression: • Name •ID • The Table in which the new expression attribute will be placed
Type	Enables you to select the expression type: • Per record • Aggregate • Lookup • Switch
Expression editor	Enables you to define what the expression will compute.
Results panel	Displays the list of unique values of the expression and the frequency.
Help button	Opens the Expression help dialog.
ADVANCED...	Opens the Advanced Settings dialog.

Note: Within the general information by default the Name is linked to the ID. This can be turned on and off by pressing the link sign. When turned off it is possible to change the name without changing the ID, or vice versa.