This post is a little bit off the beaten path for the DataTables blog. Rather than discussing DataTables or its extensions, here I will present one of the tools that SpryMedia uses to help conduct its day to day business for invoicing, conforming to UK tax rules: a web API for VAT exchange rates.
In future I'll be publishing others APIs that I use to run the business (specifically a version and release notes API) and thoughts on setting up and running a business, but this post will only really be of interest to those of you are are running a business in the UK, are VAT registered and invoice in a currency that is not Sterling. If that is you, this API might make life a little bit easier, if not, then you probably won't be too interested in this article!
Editor provides built in support for the three basic buttons needed in an editable DataTable: Create, Edit and Delete. One further action that is particularly useful is the ability to create a new record using the values from an existing row in the table as the default values - i.e. a duplicate button. This can facilitate fast data entry when working with data that has common information; for example entering information from a monthly invoice into a payments database or tracking a team's score through season.
Although there isn't a built in duplicate button type in Editor, this blog post will show how that functionality can be performed very easily with the Editor API, using a TableTools button to provide the user interaction and finally creating a reusable button plug-in for TableTools that can be used in any of your tables with the addition of a single line of code.
The results of the information presented in this post can be see in the duplicate button example on the Editor site.
When building a modern web-site you will typically use a responsive design. The advantages of doing so are clear; one site that works on all devices regardless of screen size means much lower maintenance costs and an improved experience for your customers. Even better is that responsive design is built into the core of most ready-rolled CSS frameworks, such as Bootstrap and Foundation, so you can get the benefits with minimal development effort.
While the frameworks handle responsive layout for content extremely well, they don't really handle responsive tables . This is where Responsive for DataTables comes in - it uses DataTables' built in column visibility APIs to optimise the layout of the table for the screen size that the table is being viewed on.