Support Forum

[fcai]

I have a double UDF (9, 2) which take user's input of purchase cost (money).

I wonder if there is a way to render it in the way we like?

i.e.
user enter: 1235.1
display:12345.10,

which adds a 0 to the end automatically.


Also I wonder if we can convert the number into the format of currency.

i.e.

user enter:12345.1
display:$12,345.10.


Thanks,

fred

[Petr]

One way decide task used the script. Before create operation you need field check on the mask (^\d+.$\d+). next convert the number into the format of currency.
But field need type "String".

[a-b-c]

Also there is a compromise: you can create a calculated string UDF, which would show the double value in a format you want. So you will have two UDFs, one for editing the raw value (private access, for internal usage) and one for displaying the formatted value (public access, for customers and other end users).

[fcai]

thanks