In reference to a previous blog post on the implementation of DataTables. This blog post will be about how I hide columns in tables so that other functionalities can be used from DataTables in a different way.

Example 1

Scenario: You have a set of data that needs to be ordered by the date the user confirmed their email address, but you do not want to display the date. First, make a table as below and add inline styles for the column (e.g., ’email_confirmation’) that you do not want to show by adding “display: none”.

Then, in your JS, add the code below.

• The number points to the column that you are ordering the data by
• And you can either use ‘desc’ for descending or ‘asc’ for ascending order.

Example 2

Scenario: You need to export a whole DB  table either to print it or save it as an Excel, but you don’t want to display all columns on your web page.

First, make a table with the inline styles as per the previous example

Then, in your JS, add the below:

And in your CSS, add the following:

Happy Coding!