Adding and hiding fields in Table View

Adding 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 add fields 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 add fields in Table View:

1.

In Browse mode, click Modify in the layout bar.

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:

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. To define a new field, choose Manage Database.

Remove fields you added

Select one or more fields and click .

Any changes you make in the Modify Table View dialog box show in Table View as well.

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.

  •

Any changes saved in Table View do not affect Form View, List View, or the current layout but will appear the next time you view the layout in Table View.

  •

When you add fields in Table View, the style and point size of the font match the font in the left-most column of the table. If no columns exist when you click Table View, FileMaker Pro uses the default font specified in the Fonts tab of the FileMaker Pro Preferences dialog box. If you want to change the font characteristics for a field, you must use Layout mode to add the field to the layout, then format the field.

Related topics

Viewing records as a form, list, or table

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. To define a new field, choose Manage Database.
Remove fields you added	Select one or more fields and click .

Was this topic helpful? Send feedback.