Page 1 of 1

Thousand separator

PostPosted: Tue Jan 08, 2019 9:06 am
by mountain91074
Hi,

This may be a stupid question but I want to now how can we add a thousand separator comma to numeric values shown in table columns.
I've tried
'display_mask' => 'number_format(***)'
but does not work...

I appreciate if someone help me. Thank you.

Re: Thousand separator

PostPosted: Tue Jan 08, 2019 5:41 pm
by admin
You could use display_mask with a mysql function or you can use a callback function using the table_fun option.

See https://mysqlajaxtableeditor.com/Docume ... #table_fun and https://mysqlajaxtableeditor.com/Docume ... splay_mask for examples.

Re: Thousand separator

PostPosted: Tue Jan 08, 2019 11:08 pm
by mountain91074
Hi admin,

Thank you.
I mede it with following code.
'display_mask' => 'format(AAA,0)'