Re : Format Decimal

Re : Format Decimal


I have an input inside a tablerecord which variable is a decimal. But I'd like it to be formatted (somthing like 1.000.000,00).

Is this possible?

Thank's in advance,

Best Regards,

Francisco Neto
Hi Francisco,

To have that behaviour, I'd firstly set the input variable as a text type, allowing you to define the pattern format on the Preparation screen action.
On the post (save action), I'd validate and copy that text value to the decimal variable.
José Martins
I want to apply format currency in one of the text box.
The task is to convert currency into decimal in the textbox eg
if i give number 2454664 it has to convert into 24546.64 like this.
I assigned one action for this text box and i'm assigning like this 

FormatCurrency(GetBorrowerByClientId.List.Current.LoanDetail.AppraisedValue, Site.Currency, 2, Site.DecimalSeparator, Site.GroupSeparator)

but i'm getting the error saying the record is currecny data type.Please see my screenshot for reference.

Please see my screenshot.This is the error i'm getting when applying the actions inside the
textbox.How do i solve this.

Hi Franciso,
I have atatched one testing oml file with only two text box can you just show us how to
implement that.
The problem in your screenshot is that LoanDetail.AppraisedValue is of type "Text" not "Currency".

Your Test.oml file doesn't match the file that you are working with at all.