In a Table view, each row corresponds to an entry in the application while the columns show data from those entries. Columns that you specify in a table view are also used indirectly to determine what data is shown in the Compact view and Calendar view.

The left-most column contains check boxes to select entries. The remaining columns show data and they are configurable — you can add, hide or change the order of them.

By default, a new table view contains at least one field and a Summary column which shows a brief summary of the entry’s data. You can add additional columns using the Add Column link. Columns can show data from Fields as well as Derived fields and Formulas. (Find out more about how to add columns.)

Each column has a menu which can be accessed by clicking the header. In each menu is a list of commands that affect the column and/or the view. The list will vary depending on what sort of data the column contains.

• Sort to change the order in which entries (rows) are shown

• Group to cluster similar entries together

• Subtotals to add the sum, average, max, or min of a column of numeric data

• Derived fields to add a column of data from a linked entry

• Formulas to perform mathematical operations on two numeric columns

• Move to change the position of a column

• Add Filter to add a new filter using the column

• Rename and Revert to change the name of a derived field or formula column

• Edit Column to allow the user to edit the contents of a column directly in the view

• Configure to configure the field shown in a column

• Hide to hide the column from the view