133
Views
1
Comments
Solved
[jQueryInputMask] Doesnt work for displaying Currency type column 
Question
jqueryinputmask-png
Web icon
Forge asset 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.

2023-02-10 19-42-59
João Melo
 
MVP
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.