Suppose that you need to display the name of the current user. Let’s implement a virtual field that will display the current user name on the Customers form.
Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Right-click on Customers / Fields node, and press New Field.
Use the following values:
| Property | Value |
| Name | CurrentUserName |
| Type | String |
| Length | 40 |
| Allow null values. | true |
| The value of this field is computed at run-time by SQL expression. | true |
| SQL Formula | @BusinessRules_UserName
|
| Label |
Current User |
| Values of this field cannot be edited. |
true |
Press OK to save.
Let’s add this field to the edit form. Drop Customers / Fields / CurrentUserName (String(40)), read-only) node onto Customers / Views / editForm1 node. This will instantiate a CurrentUserName data field.
On the toolbar, press Browse. Navigate to the Customers page and select a record. The Current User data field will display the user name at the bottom of the form.
Log out, and log in as user / user123%. The current user will change to reflect the current user account.
