Help

Adding and viewing data
F
ILEMAKER PRO HELP 64
Setting display options for Table View
While viewing data in Table View in Browse mode, you can resize or reorder the columns, change
the background or alternate color, or restore the default display settings.
Notes
• To use the column heading to create fields in Table View, you have to select the Include
column headers option in the Table View properties. To display Table View properties,
right-click a column heading or the left or right margin and choose Table View
> Edit
Properties. See
Setting up form, list, and table views for a layout.
• You can’t use Table View to change the schema for related tables or external data sources.
To change the schema for related tables, use the Manage Database dialog box.
• To reorder, resize, or sort data in Table View, you can select multiple columns but you can't
select multiple cells.
• Table View displays fields from the body part of the current layout. If a layout contains a
portal, Table View displays the data from the first related record (the first row of the portal).
• Global fields display one value for all records. You can edit a global field in any row of the
table. See Defining global fields (fields with global storage).
• Popovers do not appear in Table View unless they are in the header or footer part.
To Do this
Reorder columns Drag a column heading to a new location.
Resize a column Move the pointer to the edge of the column heading. When the pointer changes to a
double arrow, drag it to the desired size.
Set a precise
column width
Select one or more column headings. Right-click, then choose Table View > Set
Column Width from the shortcut menu. In the dialog box, type a width, choose
units from the list, then click OK.
Edit Table View
properties
Right-click a column heading or the right or left margin and choose Table View >
Edit Properties.
Change the color
of the background
Right-click the left or right margin of a record, choose Part Color from the shortcut
menu, then choose a color. The color of the row for adding new records and the
column for adding new fields will be slightly darker than the main background color.
Display a different
background color
for alternating
records
Right-click the left or right margin of a record, then choose a color from the
Alternate Color shortcut menu. If you customized the color or filled the part with an
image, the part is locked.
Create a dynamic
report
You can group data by a field, display subtotals for a field, or create subtotals for
each group of data. If you customized the color or filled the part with an image, the
part is locked.
Restore the default
display settings
Right-click a column heading or the left or right margin and choose Table View >
Reset from the shortcut menu.
Note Resetting Table View only changes the settings for the appearance of the
table. For example, it removes any leading and trailing subtotals and fill colors that
you added to the table. Resetting a table doesn’t have any impact on the data. For
example, if you created fields and added records to the table, resetting the table
doesn’t delete the fields and records.