Blog
On the DataTables blog you will find news, announcements and tutorials about DataTables and its suite of extensions. New posts are published (usually!) monthly, with additional news items in between.
Refreshing data before editing
A web-based CRUD system such as Editor is by its very nature concurrent - i.e. multiple users could be updating data at the same time. Those users might be in the same office, or they might be on opposite sides of the world, but one thing you don't want to happen is for one user to make updates to a row, then have another user undo those changes by submitting information without realising it has changed already.
Ultimately the best solution for this is to update the data in the table in real-time - that is a complex topic and something we will be exploring in future (stay tuned!), but in this post I would like to introduce a mechanism that can be used with minimal code effort and no disruption in an existing code base: refreshing the data for the row(s) to be edited when the user triggers editing on a row.
To do this, we'll develop a new Button that can perform this action before triggering editing, in a reusable component. The result is shown below (note that this looks very similar to standard editing in Editor, but an Ajax request is used to refresh the data when clicking Edit. A second browser window showing this page can be used to create your own form of concurrency, updating the data from one in the other:
| Name | Position | Office | Salary |
|---|---|---|---|
| Name | Position | Office | Salary |
Installing Editor in WordPress
There's been several forum questions recently asking how to configure DataTables or Editor within a WordPress website. This blog post provides a simple demonstration to quickly get DataTables and Editor working on your page. In this demonstration we show how to install DataTables in WordPress using two different methods:
- Direct script inclusion for fine grained control
- TablePress - a WordPress plug-in by Tobias Bäthge for a fully integrated DataTables / WordPress editing environment.
We also discuss how to install and configure Editor using direct inclusion.
Parent / child editing in child rows
Happy New Year everyone. Last year we took a bit of a step back from the blog while focusing on other aspects of DataTables, the extensions and support, but in 2019 we will be more regular with blog posts. To get us started we are going to revisit the Editor parent / child post. Parent / child editing is quite a popular topic for when you have one-to-many database structures, letting end users edit data from both tables on a single page.
The most frequent question about the previous post is "how do we do this with child rows, rather than having a child table always shown?" So that's what we are going to explore in here. As a quick start, here is the result we are aiming for:
| Name | Users |
|---|
Historic blog posts
- Debugger update 12th Jul 2018
- SearchFade 8th May 2018
- Vertical scroll fitting 31st Dec 2017
- Experiment: SearchPane 30th Nov 2017
- Queuing changes in Editor 24th Oct 2017
- Cascading lists in Editor 1st Sep 2017
- Editor and NPM 31st Aug 2017
- Deep linking into DataTables 24th Jul 2017
- Always visible editing panel 30th Jun 2017
- Iterators in DataTables 31st May 2017
- RowGroup - new extension 7th Apr 2017
- Ajax loaded row details 31st Mar 2017
- Locale based sorting 28th Feb 2017
- Search highlighting with mark.js 19th Jan 2017
- Sorting with absolute positioned data 23rd Dec 2016
- Editor 1.6 16th Dec 2016
- Dynamic enum sorting 16th Jun 2016
- Spring updates - 2016 24th May 2016
- Parent / child editing with Editor 25th Mar 2016
- Ellipsis renderer 26th Feb 2016
- Generator update 21st Jan 2016
- Download statistics 31st Dec 2015
- NPM and Bower 9th Nov 2015
- Editor's server-side events 2nd Oct 2015
- Multi-row bulk editing 11th Sep 2015
- Update extravaganza 13th Aug 2015
- Git repo structure update 2nd Jun 2015
- DataTables 1.10.7 30th Apr 2015
- Vertical page fitting 10th Apr 2015
- Editor 1.4 / DataTables 1.10.5 12th Feb 2015
- Ultimate date / time sorting plug-in 18th Dec 2014
- Editor 1.4 beta - .NET 4th Dec 2014
- Table captions 7th Nov 2014
- Search result highlighting 22nd Oct 2014
- DataTables 1.10.3 9th Oct 2014
- Sliding child rows 2nd Oct 2014
- Alphabet input search - Part III 22nd Sep 2014
- Permanent inline checkboxes 9th Sep 2014
- Alphabet input search - Part II 2nd Sep 2014
- Alphabet input search - Part I 26th Aug 2014
- Business: UK VAT exchange rates 8th Aug 2014
- Duplicate buttons in Editor 25th Jul 2014
- Introducing Responsive for DataTables 16th Jul 2014
- DataTables 1.10.1, Editor 1.3.2 and more 15th Jul 2014
- Nominet Internet Awards shortlist 17th Jun 2014
- Font Awesome integration 6th Jun 2014
- Support and forums updates 26th May 2014
- DataTables 1.10.0 released 1st May 2014
- DataTables 1.10.0 release candidate 25th Apr 2014
- DataTables 1.10 beta 4th Feb 2014
- HTML 5 Clipboard and File APIs 31st Jan 2014
- JS Bin update 24th Jan 2014
- Orthogonal data 9th Jul 2012
- Inline editing 31st May 2012
- Introducing Editor 4th May 2012
- DataTables debugger 26th Feb 2012
- Twitter Bootstrap 2 1st Feb 2012
- Microsoft CDN 28th Jan 2012
- localStorage for state saving 16th Jan 2012
- Twitter Bootstrap 8th Dec 2011
- Site updates - JS Bin and more 1st Nov 2011
- Getting started with DataTables 27th Aug 2011
- DataTables support 29th Jun 2011
- Drill-down rows 19th Jun 2011
- Introducing Scroller 11th Jun 2011
- DataTables 1.8 4th Jun 2011
- Creating beautiful and functional tables with DataTables 10th May 2011
- Extended data source options with DataTables 1st May 2011