How do you sort on multiple fields in a list?
Clicking on the column header will sort a list ascending or descending on that specific field.
If you wish to add a secondary sort on another field hold the Shift key while clicking on the column header of the second field. Alternatively right click on the column header and choose which sort direction you would like for the second sort.
A number is added next to each sort arrow to indicate where it is in the sort order. Any number of fields can be added to the sort order.
Related Articles
Appendix I - Special/calculated fields
A number of special/calculated fields exist in the system that are not used in the Form Editor but can be added as columns to lists. These fields are designed to provide specific information and vary depending on the table they are connected to. ...
Why don't fields appear in the Filter Builder?
Only those fields that are displayed as columns in the List appear in the Filter Builder. If you wish to use a field in the Filter Builder but not display it, then it can be marked as Invisible.
How can Registered Providers be setup to use multiple teams?
The Landlord and Team structure within the system allows for flexible filtering of data so that users are only able to access the data that is relevant to the their roles. However for some users, i.e. managers, they may require a wider view of the ...
Release v2.7.1 10/08/2021
New & Improved Back office Case officers A new Case Officers list has been added. Anyone with permissions to view Cases will also have access to this new list. Only Cases that have a Case officer assigned are displayed in the list. If a case has ...
Reporting training
9:15am Lists Filtering & Sorting Column chooser Exporting data 10:30am Break 10:45am Filter Builder Saving lists Dashboards Permissions 12:45pm End