Back Interface

The Data Grid

Beyond the simple HTML table. Handling sorting, complex filtering, inline editing, and massive datasets without compromising performance.

The data grid is the undisputed workhorse of the back office. While designers often try to replace tables with card layouts or lists to make interfaces feel more "modern", nothing beats the scannability and density of a well-constructed grid for structured data.

Anatomy of a Data Grid

A robust data grid consists of several interconnected systems:

  • The Viewport: The visible area, usually implementing virtual scrolling for large datasets.
  • The Header: Contains column labels, sort controls, and often inline filter inputs.
  • The Action Bar: Contextual actions (Bulk Actions, Export, Column Visibility).
  • The Pagination/Footer: Controls for navigating datasets that aren't infinitely scrolled.

Key Principles

1. Alignment is Information

Never centre-align data in a grid. It destroys scannability.

  • Text: Left-align.
  • Numbers (Currency, Metrics): Right-align. This allows decimal points and magnitudes to align vertically.
  • Dates: Left-align (or right-align if fixed width).
  • Badges/Status: Left-align.
Transaction ID Amount Status
TX-99210 $1,245.00 CLEARED
TX-99211 $84.50 PENDING

2. Frozen Columns and Headers

For wide datasets, the identifying column (usually the left-most, such as ID or Name) must remain frozen while the user scrolls horizontally. The header must always remain frozen during vertical scroll.

3. Density Modifiers

Provide users with control over row height. A standard pattern is offering 'Comfortable' (48px), 'Compact' (32px), and 'Dense' (24px) options, persisting this preference to the user's profile.

Common Mistakes

MistakeCorrection
Truncating vital data with ellipses.Allow column resizing or text wrapping for critical fields.
Hiding actions behind a hover state.Actions must be discoverable and accessible via keyboard without mouse movement.
Using non-tabular fonts for numbers.Always use a font with tabular numerals (tnum) for predictable vertical alignment.

Next Steps: Explore the Column Allocator Tool to mathematically distribute widths.