AdapTable Features

Powerful multi-column query expression applied across the whole grid

Per-column filtering with multiple conditions and AND / OR logic

Quickly filter a column by a chosen subset of its distinct values

Build your own custom rules for bespoke Column and Grid filtering

See data in standard column and row form

Group rows by one or more columns, with configurable expand state

Organise columns under header groups with their own expand state

Pin columns to the left or right edge so they stay visible while scrolling

Per-column width, with autosize and fill-the-grid behaviours

Persist initial sort order — including multi-column and Custom Sorts — as part of a Layout

Dedicated Pivot Layout for configuring pivoting requirements

Aggregated summary columns automatically appended to the right of a Pivot Layout

Weighted mean of a value column against any chosen weight column

Returns a value only when it is the single distinct value in the aggregated group

Summary panel showing aggregations across the currently selected cells

Pinned rows that display aggregations across grouped rows

Derive a value dynamically from other rows in the grid using a standard expression

Derive a value dynamically from multiple, distinct rows using an Aggregation expression

Apply an aggregation cumulatively to each row in a specific, ordered sequence

Bucket each row's value relative to other values in the group (quartiles, deciles, etc.)

Buttons added to Action Columns that trigger bespoke actions

Built-in Row Commands (e.g. Edit, Delete) wired up via the Row Form to handle common Action Column use cases

Format numeric cells with built-in presets (dollar, percent, scientific, etc.) or bespoke rule with decimals, separators, prefixes etc.

Format date and datetime cells using built-in presets or a custom format pattern

Transform string cells with case, trim and truncation rules

Interpolate values from other columns into a string template for richer cell content

Heatmap-style cell background that scales with the cell's value

Render a horizontal percentage bar inside the cell

Display cell values as coloured pill badges

Inline mini-chart per row, perfect for trend visualisation

Value, target marker and qualitative ranges rendered inside the cell

Render numeric values as star (or other symbol) ratings

Show where a value sits between a configured minimum and maximum

Map cell values to icons, with optional colour and tooltip

Flash cells momentarily on value change, with direction-aware colour

Flash a whole row in response to a data change — useful for data that changes infrequently

Extend and customise the light or dark themes to match your requirements

Define and extend the colour palette used across AdapTable

Support for AG Grid's charting with additional features for persistence and multiple chart windows

Route filtered grid data into Highcharts, Plotly, ECharts or your in-house chart

Alerts that trigger whenever a column's value changes

Alerts that fire in response to value changes by a configured amount or percentage

Alerts that fire when a whole row is added, updated or deleted

Alerts that are triggered when a column's aggregation crosses a configured threshold

Alerts that react to changes in grid (e.g. has this not changed in last hour? is this value the highest its been today?)

One-off or recurring scheduled alerts using full Cron expressions

Alerts that fire when proposed cell edits fail your business rules

Cell-based annotations a user keeps for personal reference

Cell-based threaded conversations between colleagues, timestamped and attributed

Add ad-hoc free-form text annotations as user-defined columns

Saved export definitions covering columns, rows, format and destination

Build your own reports for proprietary export

Choose the output format for a Report: Excel, Visual Excel, CSV or JSON

WYSIWYG Excel export that preserves AdapTable styles, formatted columns and row groups in the spreadsheet

Route exports to download, clipboard, email or any custom destination

Send exports anywhere — cloud storage, PDF services, internal APIs — via a function or runtime Form

Cron-driven recurring exports that run without user intervention

Apply maths operations across many selected cells in a single action

Set the same value across every selected cell at once

Nudge numeric cell values up or down with configurable steps

Keyboard shortcuts for entering common values into cells

Dropdown editor populated with the column distinct values, or with custom values you provide

Number-only editor with min, max, step and decimal places controls

Number editor that displays and validates values as percentages

Pop-up calendar for editing date cells, with configurable formats and bounds

Decide per-cell whether editing is allowed at all, based on the current value

Block or warn on invalid edits in the browser using Alert-style rules

Round-trip cell edits to your server before they hit the grid

Configurable strip above Grid which displays toolbars (either in Tabs or Pinned above Grid and including custom toolbars), a quick search component and Module Buttons; floating, docked, tabbed and minimised modes available

Main configuration panel where users manage all modules and launch wizards to create and edit Adaptable objects

Sidebar panel that hosts per-module configuration and quick actions

Bottom strip of the grid showing live metrics, statuses and custom info

Customisable per-column menu of actions, with built-in and user-defined items

Customisable right-click menu, with built-in and user-defined items

Movable, resizable windows with developer-supplied content — useful for multi-monitor setups

Customisable splash and loading indicator shown during AdapTable boot

Show progress UI for long-running AdapTable operations

Visual UI for users to construct expressions without writing code

Inline expression input with autocomplete and validation

Declarative, schema-driven dialog used across AdapTable wizards, popups and custom destinations

Consistent, configurable, button used across toolbars, menus, dashboards and your own components

Lightweight icon — pick from the AdapTable icon set or supply your own

Multi-step UI primitive for guiding users through complex configuration

Pre-seed AdapTable with default user state from your application

Plug localStorage, REST or your own backend in to save user state

Bump and migrate user state when your configuration schema evolves

Programmatically read, mutate or replace AdapTable's state at runtime

Listen to every change in Adaptable State — the main hook for monitoring grid activity and integrating with external systems

Store bespoke application data alongside AdapTable state via the Application section or a custom `saveState` hook

Keep shared entities 'live' — changes made by one user propagate to every other user sharing the object

Share complex objects together with all dependencies, e.g. sharing a Layout automatically pulls in any Calculated Columns

The full programmatic surface for driving AdapTable from your code

Compile-time configuration object that bootstraps an AdapTable instance

Subscribe to lifecycle and behaviour events emitted by AdapTable

The first event AdapTable fires once initialised — exposes the Adaptable API and AG Grid API to your application

useAdaptableApi, useAdaptableState and useCurrentLayout for React apps

Build and ship AdapTable views without writing TypeScript

Lightweight query language behind Filters, Styles, Alerts, Calculated Columns, etc; includes standard, aggregated, cumulative, quantile, observable and relative change expressions and supports custom functions and advanced logic (IF, CASE, QUERY, FIELD, VAR, etc)

Inject application-specific context that is then surfaced to predicates, formatters and event callbacks

Live runtime metrics exposed for monitoring dashboards

Show detailed metadata about any grid column on demand

Programmatic and API-driven row and cell selection, including checkbox columns

Highlight changed cells and jump directly to them on demand

API surface for adding, updating and deleting rows and cells

Define non-business days and use them in date filters and reports