Help

Adding and viewing data
F
ILEMAKER PRO HELP 65
Displaying and hiding fields in Table View
After you define a field, you can use Layout mode to place the field on any layout (assuming you
have access privileges to do so). See Placing and removing fields on a layout. When you are
working in Table View, you can display additional fields that are not on the current layout and hide
fields that show in Table View.
Note When you display existing fields that are not on the current layout in Table View, they are not
added to the layout so they do not appear in any view other than Table View. Likewise, if you hide
fields in Table View, fields are not removed from the layout and are visible when users view the
layout in other views.
To display fields in Table View:
1. In Browse mode, right-click the table column heading, and choose Table View > Modify or
click Modify in the status toolbar.
The Modify Table View dialog box appears, listing the fields currently displayed in Table View.
2. You can use the Modify Table View dialog box to do the following:
3. Click OK to save changes or click Cancel to discard changes.
Notes
• Fields on the current layout are marked with a lock icon in the Modify Table View dialog box,
indicating they can’t be removed from the list. You can prevent these fields from displaying in
Table View by clearing their checkbox.
• When you add fields (columns) in Table View, the style and point size of the font are determined
by the layout theme’s default font settings. If you want to change the font characteristics for a
field, you must use Layout mode to format the field.
Related topics
Viewing records as a form, list, or table
Creating dynamic reports in Table View
You can use Table View in Browse mode to group your data by a field, display subtotals for a field,
create subtotals for each group of data, or display a grand total for a group of data.
Note You can view the quick report only in Table View. The changes you make have no impact on
the current layout.
To Do this
Hide fields Clear checkboxes for the fields you want to hide in Table View.
Reorder columns
Drag the next to a field to reorder fields in the list and in Table View.
Display additional fields
Click to open the Add Fields dialog box, then choose a field to add
and click OK. To choose a field in another table, choose the table from
the list above the list of fields, then choose a field. To define a new
field, choose Manage Database from the list.
Remove fields you added
Select one or more fields and click .