Help

Adding and viewing data
F
ILEMAKER PRO HELP 62
Working with fields
While viewing data in Table View in Browse mode, you can create, modify, or delete fields.
Note You must log in using the Full Access privilege set to modify fields in Table View.
To Do this
Create a field For the first field, click Create Field in the column heading for the first column of the
table. To create additional fields, click + in the column heading. A new column is
added on the right in the table.
To cancel creating the new field press Esc before submitting the change.
You can prevent new fields that you create from being automatically placed on the
current layout by deselecting Add newly defined fields to current layout in the
Preferences dialog box. See
Setting layout preferences.
Change a field
name
Double-click the column heading for the field you want to rename, then type the
new name.
To discard changes to the field name, press Esc before you exit the column
heading.
Tip You can press Tab or Shift-Tab to edit the field names. If you press Tab in the
far right column heading, FileMaker
Pro creates a new column.
For information about field names, see About naming fields.
Choose a field type Right-click the column heading, choose Field > Field Type to display a shortcut
menu, and choose a field type. For more information about field types, see About
choosing a field type.
The default field type is Text.
Set field options Right-click the column heading, then choose Field > Field Options. See Setting
options for fields.
Sort records by
one or more fields
Select a column heading and optionally Ctrl-click (Windows) or Command-click
(OS
X) additional headings. Right-click one of the selected column headings and
choose Sort Ascending or Sort Descending. A sort icon appears on the column
headings indicating the sort setting.
If you select multiple columns, the order in which columns are selected determines
the sort order.
Remove a field
from a multi-field
sort order
Select an unsorted heading to deselect the columns you are sorting by, then right-
click the heading you want to remove from the sort order and choose Remove
<field
name> from Sort. You can Ctrl-click (Windows) or Command-click (OS X)
multiple headings to remove more than one field from the sort order.
Sort records by a
predefined value
list
Select any column heading, right-click, then choose Sort By Value List, and
choose a value list.
Remove one or
more fields from
the sort order and
re-sort
Sort the file by two or more fields, select then right-click the column heading you
want to remove from the sort order, choose Remove <field name> from Sort.
When you release the mouse, data re-sorts based on the fields that remain in the
sort order.
Tip Click Sort in the status toolbar to view the current sort order.
Unsort the file Right-click any column heading in a sorted file and choose Unsort.