User manual

Table Of Contents
Chapter 9 Using Fields 77
8 Use the Fields pane to add or display fields.
Note In table view, you cannot see related data fields or any of the list field types, such
as address, email address, file list, message list, and simple list.
Creating Calculation Fields
To create a calculation field:
1 Choose Insert > New Field or press Control-N.
2 Choose Calculation.
3 Click Continue.
4 Name the field.
5 Build a formula for your calculation.
6 Choose the correct data type for the result you want and set any other options.
To Do this in the Fields pane
Add a field to a form in form view or split view Drag the field to the form.
Display a field as a column in table view or split view Select a field’s checkbox.
To add Do this
A reference to a field In the Available Fields list, double-click a field name.
A mathematical or
text operator
Click an operator button or type an operator in the formula.
The current date Click Today to insert the current date.
The current time Click Now to insert the current time.
A pre-formatted
value
Click Value, then select a value from the list. Replace the pre-formatted value with
the value you want.
This is what you see in
the calculation field for
the current record.
The formula for the
calculation. In this
example, it’s the value in
First Name, a space, and
the value in Last Name.
Operator buttons