Data & Reports
Sorting a table by any column
- Click a column heading to sort the table by that column. A small arrow beside the heading shows which column is sorting and which way; headings with a faint up-down arrow can be clicked too.
- Click the same heading again to flip it — oldest to newest, highest to lowest, Z to A.
- The first click puts dates newest first and numbers and references highest first; names and other text go A to Z. Status columns sort by how urgent they are — expired or overdue first — rather than alphabetically.
- Blank cells always go to the bottom, whichever way the column is sorted, so an item with no due date never shows up as the earliest one.
- On a long register the sort covers every row that matches your filters, not just the page you're looking at, and it stays in place as you move between pages. Where a list is grouped under headings, it sorts within each group.
- Inspections: open one from your filtered, sorted list and the top of the page shows where you are (3 of 12), with arrows to the previous and next one in that same list and a link back to it. Sign one off, then press the right arrow for the next. The list is remembered for that browser tab only.
- Exports follow your sort: the Excel, PDF and CSV files come out in the order you sorted by, and the header at the top of the file says so (for example "Sorted by Due, ascending"). Click Export after you have sorted and the file matches what is on screen.