Sorting to View Records

Introduction

Feature(s)

Sorting records can help arrange records in a certain order and then display them. The followings are the fields available to be sorted.

Application Scenario(s)

When viewing records on Manage Data page and in the permission sets, you can sort and view records. For example, in a Fruit Order form, you can select Descending for a Total Price field to check the biggest orders.

Preview

Setting Procedure

Where to Set

1. Sort on the Manage Data page.

On the Manage Data page, Click  and then click Sort , or click to sort records.

2. Sort in the permission sets.

The settings for records sorting in Manage Data are the same as those in the permission sets.

Rule(s) of Sorting Records in a Grid

Click Sort to sort records.

Sorting Records in a Field

Click  in a field to sort records. Except for Member/Members/Department/Departments fields, you can sort records from other fields in an ascending or descending order.

Then or will appear in the field. And records will be sorted in an ascending or descending order as you set.

If you select a Member/Members/Department/Departments field, select Sort by Same Value. Then you can group the records of the same member or department together.

For example, the records of the same member are grouped together.

Canceling Sorting

If you need to cancel the sorting, click , Sort, and then .

You can also re-click the sorting method you selected to cancel the sorting. For example, re-click Ascending to cancel the sorting.

Notes

1. You cannot sort records for sub-fields.

2. Except for Member/Members/Department/Departments fields, you can sort records from other fields in an ascending or descending order.

3. If multiple sorting rules exist, they will take effect in the order in which they are set.

4. Each field can only be included in a sorting rule once, and you can add a maximum of five sorting rules.