Blog

On the DataTables blog you will find news, announcements and tutorials about DataTables and its suite of extensions.

Latest posts

20th Sep 2024
By Allan Jardine -

Address auto-complete with Editor

When building data input forms with Editor, there are various ways in which a developer can make the end user's life a lot easier - clean, concise, and clear forms are one of Editor's strengths, but you can also make data entry easier for the end user using lookups and auto-completion. There is a good chance that you'll have come across an address auto complete when signing up for services or shipping items on the internet - this article will do a deep dive on how we can do that in Editor.

To start, let's skip straight to a working example so you can see what we are going to build - below is a table with three made up addresses. It is fully editable per a regular DataTable with Editor (local editing in this case - no backend database for this example). The part that is of interest in this blog post is if you create a new record or edit an existing one - the second field isn't a data field, rather it is an input that lets the user start to type an address, which will then be looked up using the excellent Geoapify API. A list of options are presented to the end user (you in this case!), refined as they continue to type, and lets them click on one to auto-complete the fields in the form.

Name House Street City County State Postcode Country
Airi Satou The Ivies Glebe Close London London NW11 9TU United Kingdom
Hope Fuentes 392 Maple Street Los Angeles California 90017 United States
Serge Baldwin 28 Chemin Du Lavarin Sud Caen Basse-Normandie 14000 France

Continue reading...

21st Aug 2024
By Allan Jardine -

DataTables React component

This is long overdue - it turns out React isn't just some passing fad (who knew! </sarcasm>), so it is with a degree of relief mixed with the usual pleasure of announcing new software that with this post I am introducing a React component for DataTables.

The new DataTables component for React is basically a wrapper around the existing DataTables library, exposing it in a way that will be immediately familiar to those who are used to working with React, while still making all of DataTables features available.

This post will discuss how to install and use the new component to get the benefits and use of DataTables in your React application. There are also a number of examples (such as this simple use case) presented so you can try the component out live.

Continue reading...

26th Jul 2024
By Allan Jardine -

Ordering sequence plugin

I recently had an interesting question from a developer who wanted to show their end users a visual representation of the ordering sequence applied to a DataTable when multi-column ordering. For example, if you have two columns in the ordering, it can be useful to know which one DataTables is using for the primary order, and which for the secondary.

DataTable's default styling does include shading for cells in an ordered column, but the difference between primary and secondary ordering is intentionally subtle. To make it stand out more, I came up with the idea of showing a number label next to the order indicator. In the example below the first and second columns are used for primary and secondary ordering respectively and you can see the number at the top of each column:

NamePositionOfficeSalary
Tiger NixonSystem ArchitectEdinburgh$320,800
Garrett WintersAccountantTokyo$170,750
Ashton CoxJunior Technical AuthorSan Francisco$86,000
Cedric KellySenior Javascript DeveloperEdinburgh$433,060
Airi SatouAccountantTokyo$162,700
Brielle WilliamsonIntegration SpecialistNew York$372,000
Herrod ChandlerSales AssistantSan Francisco$137,500
Rhona DavidsonIntegration SpecialistTokyo$327,900
Colleen HurstJavascript DeveloperSan Francisco$205,500
Sonya FrostSoftware EngineerEdinburgh$103,600
Jena GainesOffice ManagerLondon$90,560
Quinn FlynnSupport LeadEdinburgh$342,000
Charde MarshallRegional DirectorSan Francisco$470,600
Haley KennedySenior Marketing DesignerLondon$313,500
Tatyana FitzpatrickRegional DirectorLondon$385,750
Michael SilvaMarketing DesignerLondon$198,500
Paul ByrdChief Financial Officer (CFO)New York$725,000
Gloria LittleSystems AdministratorNew York$237,500
Bradley GreerSoftware EngineerLondon$132,000
Dai RiosPersonnel LeadEdinburgh$217,500
Jenette CaldwellDevelopment LeadNew York$345,000
Yuri BerryChief Marketing Officer (CMO)New York$675,000
Caesar VancePre-Sales SupportNew York$106,450
Doris WilderSales AssistantSydney$85,600
Angelica RamosChief Executive Officer (CEO)London$1,200,000
Gavin JoyceDeveloperEdinburgh$92,575
Jennifer ChangRegional DirectorSingapore$357,650
Brenden WagnerSoftware EngineerSan Francisco$206,850
Fiona GreenChief Operating Officer (COO)San Francisco$850,000
Shou ItouRegional MarketingTokyo$163,000
Michelle HouseIntegration SpecialistSydney$95,400
Suki BurksDeveloperLondon$114,500
Prescott BartlettTechnical AuthorLondon$145,000
Gavin CortezTeam LeaderSan Francisco$235,500
Martena MccrayPost-Sales supportEdinburgh$324,050
Unity ButlerMarketing DesignerSan Francisco$85,675
Howard HatfieldOffice ManagerSan Francisco$164,500
Hope FuentesSecretarySan Francisco$109,850
Vivian HarrellFinancial ControllerSan Francisco$452,500
Timothy MooneyOffice ManagerLondon$136,200
Jackson BradshawDirectorNew York$645,750
Olivia LiangSupport EngineerSingapore$234,500
Bruno NashSoftware EngineerLondon$163,500
Sakura YamamotoSupport EngineerTokyo$139,575
Thor WaltonDeveloperNew York$98,540
Finn CamachoSupport EngineerSan Francisco$87,500
Serge BaldwinData CoordinatorSingapore$138,575
Zenaida FrankSoftware EngineerNew York$125,250
Zorita SerranoSoftware EngineerSan Francisco$115,000
Jennifer AcostaJunior Javascript DeveloperEdinburgh$75,650
Cara StevensSales AssistantNew York$145,600
Hermione ButlerRegional DirectorLondon$356,250
Lael GreerSystems AdministratorLondon$103,500
Jonas AlexanderDeveloperSan Francisco$86,500
Shad DeckerRegional DirectorEdinburgh$183,000
Michael BruceJavascript DeveloperSingapore$183,000
Donna SniderCustomer SupportNew York$112,000

Use shift click on the column headers to trigger multi-column ordering on the table, and note the indicators change. When ordering is applied to a single column only, no additional indicator is shown.

Continue reading...

Historic blog posts

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2012

2011