Please wait...

Currency, percentage and other columns

Video versionA video overview of Currency, percentage and other columns in wpDataTables

Currency, percentage and similar column in wpDataTablesHow to display numeric data with additional symbols (currency, percentage, units)

Sometimes you need more than an integer or a float column when you’re referring to a percentage, or to amounts in euros, dollars, etc.

Adding all these examples as column types would make the plugin usage confusing for users, so we found a different solution: we¬†added a “Cell content prefix” and a “Cell content suffix” block for each of the column settings.

cell content prefix suffix

Whatever you enter in the “Cell content prefix” (for example a $, or other currency sign) will be rendered in each cell of this column before the actual cell value; whatever you enter in the “Cell content suffix” (For example “%” or “pcs.”) will be rendered after the actual cell value. These entrees will not affect sorting, filtering, or any other column functions.

ExampleDemo table with currency columns

E.g. for this table the “Yearly revenuecolumn has a “$” sign defined in the “Cell content prefix“:

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.