Format datatable column to show currency value

Forms
1

Hi,

I am looking for some help with formatting a datatable column to show numerical values as currency. I have managed to use the following code for numeric fields:

fd.field('expenditure').widgetOptions = {
format:"c2",
step:"10",
}

This does not work when I attempt to apply this code to a field within the datatable. Is there any way I can get this to work within the data table for a particular column?

Thanks.

2

Hello @hutchisoni,

Currently, it is not possible to format a column to display values as a currency.

This functionality is on our roadmap but will take time to develop.

Are you considering a paid support option?
With paid support, we can hasten the process and deliver it in the nearest future. If you are interested, please contact us via [email protected].

3

No problem, thanks for getting back to me.

Can you please let me know if there are currently any workarounds for this?

For example, is it possible to add fixed decimal places to a number column using javascript, and if so, do you have an example? I could then just place the currency symbol in brackets in the title.

Thanks again for your help.

4

@hutchisoni,

No, there is no workarounds to change formatting of the column in DataTable control.