User manual

Table Of Contents
Chapter 8 Using Fields 83
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.
After you have created a field, you can enter data into it.
Creating Calculation Fields
To create a calculation field:
1 Choose Insert > New Field.
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 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
Operator buttons