Field Currency

impex09

Hi, I have a field named "payment" in my database is type float,
In the datatable only show the number like this: 4567.56 I would like set a mask to show like this: $4,567.56 how I can do it?

kthorngren

Checkout this page:
https://datatables.net/manual/data/renderers

You will want to use columns.render.

Kevin

impex09

Thank you, I resolved it using this:

{
data: 'price',
render: $.fn.dataTable.render.number( ',', '.', 2, '$' )
}