Please wait...

wpDataTables Settings

Video versionSee a video tutorial on configuring the plugin

Main settings tabSkin, data formats, and other primary plugin settings

settings main tab language date format time format

Interface language

wpDataTables comes with 45 worldwide languages for the main interface features (provided by jQuery DataTables internationalization). You can have the interface presented in your language by selecting it from this selectbox.
Only the main table features are covered in this language interfacing package. This means that table tools such as “Copy”, “Print”, “Excel”, etc., and advanced filtering labels aren’t translated, although you can translate them yourself if you wish.

Date format

This selectbox allows you to choose from 11 common date formats for use in the date columns, and for all responsive datepickers.

Time format

This selectbox allows you to choose between a 12H time format and a 24H time format. It will be used in the time column and for all time pickers.

settings main tab base skin number format decimal places

Base skin

wpDataTables has several built-in skins you can use to set the general look and feel of the table front-end. With this tab, you can choose one of them.

Number format

With this tab you can choose the output format for the numbers – which sign to use for the thousands separator, and which sign to use for decimals.

Render advanced filter

With this tab you can select the advanced filtering position when filtering is enabled – in a table header or footer (it is also possible to render filters in a form above the table, and this can be defined per table).

Decimal places

This tab enables you to define how many decimal places the floats will have, so they’ll render in a similar manner. This setting can be overridden for specific columns.

settings main tab tablet width mobile width align number

Tablet width

With this setting, you can redefine the width the plugin will recognize as the tablet width. It can be used to trigger the responsive mode on desktops as well – and set the width (to 1920 for example).

Mobile width

This setting allows you to redefine the width the plugin will recognize as the mobile device width.

Tables per admin page

This setting allows you to determine how many tables will be visible in the “Browse wpDataTables” admin page. This setting is also used for “Browse wpDataCharts”.

Align numbers to the right

If this checkbox is checked, all numbers will be aligned to the right in the table columns.

settings main tab functions purchase code

Sum functions label, Average functions label, Minimum functions label, Maximum functions label

This is where you can set the labels that will be used for Sum, Average, Minimum and Maximum functions. If you leave these inputs blank, the default labels will be “Sum =”, “Avg =”, “Min =”, “Max =”

Purchase code

The item Purchase Code from Envato settings is used to authenticate auto-updates. Its use is not mandatory.

Separate MySQL connection tabMySQL connection

Enable this setting if you want to build tables using data from a database or host different from the one you use for your WordPress installation.

Do not check this checkbox if you want to use the WordPress database connection.

separate mysql connection

If you enable this switch, you’ll also need to provide the following data to be able to query the MySQL database:

  • MySQL host: The address of the MySQL host, domain or IP-address.
  • MySQL database: The name of the database you intend to use.
  • MySQL user: The username to be used for login.
  • MySQL password: The password to be used for login.
  • MySQL port: If you use a non-standard (different from 3306) port on your MySQL server, you can define it here.
  • Test MySQL connection: Use this button to check if your settings are correct.

Color and font settings tabConfiguring the plugin frontend design

Here you”ll find a list of the settings that allow you to change the look of the tables rendered by the plugin. You can change:

 

  • Table font
  • Table font color
  • Header background color
  • Header border color
  • Header font color
  • Header active and hover color
  • Table inner border color
  • Table outer border color
  • Remove table borders
  • Remove header borders
  • Even row background color
  • Odd row background color
  • Hover row color
  • Cell color in active (sorted) columns for even rows
  • Cell color in active (sorted) columns for odd rows
  • Background color for selected rows
  • Buttons background color
  • Buttons border color
  • Buttons font color
  • Buttons background hover color
  • Buttons hover font color
  • Modals (popups used in the plugin) font color
  • Modals font color
  • Modals background color
  • Overlay background color (a background below popups that overlays the site content when they appear)
  • Buttons hover border color
  • Buttons and inputs border radius (in pixels, if you wish to have them rounded)
  • Modals and overlay color
  • Pagination color

 

You will find a short explanation beside each style setting explaining which element it will change.

Custom JS and CSS tabConfiguring JavaScript and Stylesheets for the plugin

custom js css

Custom wpDataTables JS

With this setting you can define any custom JavaScript you executed on the pages that have wpDataTables; e.g. auto-refresh, or something similar.

Custom wpDataTables CSS

With this setting you can define any CSS rules you applied to the pages that have wpDataTables. For example, hiding the search block, pagination, etc.

Use minified wpDataTables JavaScript

By default, the minified files are attached to the pages. You can uncheck this if you wish; for example, to modify the JavaScript – it’s much easier to edit the unminified files.

Info tabTechnical information

If your server setup doesn’t meet minimum requirements, you should be able to see it here, and provided with a suggestion on how to resolve the problem.

Please note: You can connect only to one server at a time.

Never miss new features!

Join 3000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

By clicking "subscribe" you consent that the information you provide via this form will be securely processed and stored in compliance with EU privacy laws (GDPR).
This  information will be used to send you newsletters as well as pre-populate any forms, should you want to edit your newsletter preferences.
You can always use this link to unsubscribe from the newsletter. You can see our Privacy Policy here.