Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Browse Column Display Fileds

Locked
nilocray
Posts: 10
Joined: Tue Apr 08, 2014 10:29 pm

Browse Column Display Fileds

Unread post by nilocray »

hi all is there a way to make to browse screen to display numbers as a currency.

thanks in advance

colin
Top
rnott
Posts: 31
Joined: Fri Mar 14, 2014 6:14 pm

Re: Browse Column Display Fileds

Unread post by rnott »

on Browse Tab, in Display column,try --> CONCAT('$', FORMAT(field_name, 2))
Top
rnott
Posts: 31
Joined: Fri Mar 14, 2014 6:14 pm

Re: Browse Column Display Fileds

Unread post by rnott »

http://dev.mysql.com/doc/refman/5.5/en/ ... ion_format
Top
nilocray
Posts: 10
Joined: Tue Apr 08, 2014 10:29 pm

Re: Browse Column Display Fileds

Unread post by nilocray »

That worked excellent thanks.
Top
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:
Contact massiws

Re: Browse Column Display Fileds

Unread post by massiws »

.
Top
Locked

Return to “General”