[jQueryInputMask] Doesnt work for displaying Currency type column 
Question
jqueryinputmask-png
Web icon
Forge component 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.

Solution

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

Let me know if that helps.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.