[jQueryInputMask] Doesnt work for displaying Currency type column

[jQueryInputMask] Doesnt work for displaying Currency type column

  
Forge Component
(5)
Published on 2017-01-23 by João Melo
5 votes
Published on 2017-01-23 by João Melo

Hi,

When you put the Jquery mask on an input field of a record with data type currency it does not take into account that the value in the field already has a decimal  in it. 

for instance:

In database: 1568756856.1234

When applying the following mask:  "000,000,000,000,000.00"

it shows :   156,875,685,612.34

when you want to pass the record to be saved in the database the value is gone and the  column in the record is 0.

In this case you would have to use a non predefined mask like this: "#,##0.0000".

Let me know if that helps.