Field currency or format for number-field

[Lars Fischer]

Is it possible to get a field for curreny (Euro) for Igrid Table Grid Plugin? Or is there an easy possibility to build such a field? It wpuld be enough to have a number field with two digits displayed after "." (like 19.80 or 2.00). Better would be a strikt format like 19,80 € or 2,00 €.

[Brian Bishop]

This code in my currency custom field - which is set for USD - could be changed to format for Euro:

view.vm

#if ($value)
$$numberTool.format('#,##0.00', $value)
#end

I can supply the full source code if you like.

[Stuti Golwala]

Hi Brian,

Is it possible to share your full code?

[francis]

Hi Stephan,

We are currently working on the calculated column feature.
You will be able to add a formula to each column of type string, integer or number.

For example:

col.linetotal.type=number
col.linetotal.formula = {quantity} * {price} * {discount}

The obvious next step is of course a number formatting capability

col.linetotal.formatNumber = "€ 0.00"

You're welcome to track following feature request
https://support.idalko.com/browse/IGRID-1824

Francis

[francis]

FYI

col.xyz.formatNumber has been released in 1.13