Sort and group records in a table

Arrange and organize visible records in a table view.

Sort records to bring values into a useful order. Group records with the same field value together. Use both features to scan related records, compare categories, and find information faster.

Sort records

1

Open sorting

Open the table view you want to organize.

Click Sort in the table toolbar.

2

Choose a field and direction

Select the field to sort by.

Click Ascending or Descending.

The toolbar shows the name of the field used for sorting. The selected sort field's column header shows or . Click that column header to change its sort direction.

Color fields sort alphabetically by color name. For example, blue sorts before red in ascending order. Icon fields use the same alphabetical ordering by icon name.

Group records

1

Open grouping

Open the table view you want to organize.

Click Group in the table toolbar.

2

Choose a field and direction

Select the field that defines each group.

Ninox groups visible records by that field. You can group by a field even when its column is hidden.

Click Ascending or Descending to set the group order.

The toolbar shows the name of the field used for grouping.

3

Clear grouping

Click Clear grouping to remove grouping.

For Rich text fields, records group together only when content and formatting are identical.