The Adaptable Blotter is a powerful, data-agnostic, HTML5 DataGrid add-on that provides you with a wide range of advanced tools for searching, filtering, sorting, styling, editing, exporting, analysing, validating and auditing your data. These will enable you to work more quickly, efficiently and productively.
The Adaptable Blotter is not another DataGrid. Instead, it sits on top of an underlying DataGrid component and extends it by providing an extra layer of functionality that contains all the additional searching, editing, sorting, exporting and styling functionality that advanced users have come to expect, and which is normally provided by in-house developers.
The Adaptable Blotter also provides a huge range of powerful, cutting-edge functionality normally missing from DataGrids but which will significantly improve user productivity and efficiency. This includes custom columns, scheduled reports, team sharing, state management, full comprehensive audit, live integrated charting and much else.
The Adaptable Blotter provides one set of screens irrespective of which underlying gird is used and one set of functionality, but a different internal implementation for each underlying grid.
You can try out the Adaptable Blotter at the Adaptable Blotter Demo Site.
This includes a subset of the functions in the Adaptable Blotter using dummy data (taken from the Northwind database).
In order to ensure maximum flexibility, the Adaptable Blotter does not assume that it will be used with, nor is it dependent on, a particular data set. Like Excel you are able to provide the Adaptable Blotter with any data set that you want, and to use whichever subset of the huge range of functions on offer which you require for your current use case.
The Adaptable Blotter will work with whichever data set you give it from whichever data source (e.g. table, database, spreadsheet, streaming data etc.)
The Adaptable Blotter does not currently ship with data adaptors; its your job as developers to populate the Adaptable Blotter with data however you wish and from whichever source you want; likewise its your responsibility to take care of what happens to the data after it has been edited in the Adaptable Blotter.
Adaptable Tools offers a consultancy service, Grid Gurus, that can work with you in attaching your Adaptable Blotter to a data source quickly and efficiently.
The purpose of the Adaptable Blotter is to give you a superior and powerful experience of visualising, managing and understanding your data while its in front of you.
The Adaptable Blotter can be used in any industry or sector. Although the initial marketing was aimed at financial services, the data-agnostic nature of the blotter, means it can be used anywhere. And increasingly its being used by clients in legal, media, retail and other sectors.
The Adaptable Blotter runs in all modern browsers. These include:
Although the Adaptable Blotter runs in a browser, it does not require internet access.
The Adaptable Blotter does not run in Internet Explorer. This browser has not been updated since 2013 and Microsoft replaced it with Edge in 2015. Many of the internal libraries on which the Adaptable Blotter relies do not support IE.
The Adaptable Blotter supports DataGrids from the leading vendors - both commercial and open-source - including Telerik Kendo, OpenFin Hypergrid and the ag-Grid (Enterprise version only). More supported grids are being included all the time.
The Adaptable Blotter will soon also support our own Grid - the Adaptable Grid - a grid control that we are currently developing to work closely with the Adaptable Blotter.
Each development team will decide which underlying grid to use for each deployment. Whichever grid is used the same Adaptable Blotter Objects (e.g. searches, filters, layouts etc) will be created, meaning that it is trivial to move from one underlying grid to another. These objects can be edited, saved and shared according to each user's settings.
The Adaptable Blotter contains a number of Functions that are designed to help you to work more quickly and efficiently. Each function has its own screen to help you manage it, and many have associated Toolbars also. All functions can be accessed from the Dashboard.
The Adaptable Blotter allows you to create your own Adaptable Blotter Objects based on your data and requirements. For more information see Adaptable Blotter Objects. Many of these objects include powerful, custom cross-column Queries that you will create.
The Adaptable Blotter includes common User Interface elements like Menus, Wizards and the Selection Tool to help you more easily find what you need.
Additionally it includes powerful Filters to enable you to find your data easily.
We advise you to take some time to familiarise yourself with these as they will save you a lot of time.
The Adaptable Blotter provides a Dashboard which is used to display quick access buttons for frequently used functions and a series of toolbars. See Dashboard for more details.