List Manager Forum

format numbers to currency $

User moon_1910 2014-12-24 05:48:06

format the numbers to dollar sign.. how?

Moonsoft support 2014-12-24 09:13:57

Hi,
the list will show the data as you entered it, so if you didn't add the $ sign when you loaded data it can't be added automatically afterwards. You have the option to set a custom style to the field, using 'Css class' property. Then you can add your custom style to that column, maybe with a background to add any sign needed.

Hope this helps, regards

User moon_1910 2014-12-24 15:11:48

Hi,
the list will show the data as you entered it, so if you didn't add the $ sign when you loaded data it can't be added automatically afterwards. You have the option to set a custom style to the field, using 'Css class' property. Then you can add your custom style to that column, maybe with a background to add any sign needed.

Hope this helps, regards



do you have a video for this? im really kinda new at this...

Moonsoft support 2014-12-26 09:47:46

Hi,
in fact this is not part of list manager configuration, what you want to add there is a specific style for a column. List manager allows to add to any column a style classs using the 'css class' parameter at each field. Now you will need to create that class at your css. There you can play with the look of that column like you do for any other part of your page.


Hope this helps, regards

User moon_1910 2015-01-01 02:25:39

I think its much more easier if you guys can add a currency option for the numbers field in the future... do you have any good reference for creating the currency format in css?

and i had also tried uploading the data with $ sign but when you edit it.. it gives out error saying i did not put decimal which the no. is formatted in decimal only and because the dollar sign is there and it is saying the error is 'there is no decimal no.'

Edited by moon_1910 - 01.01.2015 02:30

Moonsoft support 2015-01-02 09:16:31

Hi,
yes, we'll add in the future versions a free code line available for all field types, in a way you can customize the output, adding format or any other content. In the meantime, you can load your data including the currency sign, but then you would need to switch the field type to normal 'text' in order to force the validation allow the edit.

If you go for the css solution, you only need to search 'adding background image to td', your will surely find a lot of info regarding styles. This is just plain css, nothing related to the extension itself, so you can do it same way as if you were styling one html table inside an article. Here we found a working example:

http://jsfiddle.net/gHYsh/1/

the class 'test' would be the class you will set for the field, and the css that you will need to create is at the right.


Hope this helps, regards

User moon_1910 2015-01-03 11:52:04

wow.. that's a great piece of information... really appreciate it thanks... i didn't know css can do that... where do we normally save this css file?

Moonsoft support 2015-01-05 09:44:28

Hello,

You can add this css to component css file at JOOMLA/modules/mod_listmanager/assets/css/default2.css or in template css (maybe the best option) or in any css loaded on your page.

Regards,

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!