Masking double removes decimal point in back end
Masking double removes decimal point in back end
adam.owocyyc
Posts: 1Questions: 1Answers: 0
in Plug-ins
I am using https://editor.datatables.net/plug-ins/field-type/editor.mask to force a '$' character and numbers only in my field with an editor popup (MVC Core). It always returns **without **a decimal point even though the field is a double and the UI is showing a decimal point. I'm not sure is this an issue with datatables, or the jQueryMask plugin.
I have tried both of the following masks
{
label: "Tax:",
name: "taxAmount",
type: "mask",
mask: "$99999999999.00"
},
{
label: "Total:",
name: "totalAmount",
type: "mask",
mask: "$#,##0.00",
maskOptions: {
reverse: true
}
},
Answers
Can you give me a link to your page showing the issue please? I'd like to see what data is being submitted to the server when creating / editing a row, and also what is being returned from the server.
Thanks,
Allan
Was this ever resolved? I am having a similar issue.
I am trying to save 1234.23 to the backend but it's sent as an integer. Here's the relevant part of the payload:
Our accounts aren't showing that you have an Editor license - it just reports that your organisation's trial expired several years ago. Is the license registered to another email address? Please can let us know so we can update our records and provide support.
Thanks,
Colin
Hi, could someone please look into this. I've also encountered the same issue as reported above.
This is what I have for the Editor field configuration on the client:
var editor = (new $.fn.dataTable.Editor({ajax: ajaxURL,table: tableID,fields: [{type: 'mask',mask: '#,##0.##',maskOptions: {reverse: true,placeholder: '',},label: 'Bundle Price',name: 'Promotion.BundlePrice',},The masked edit field appears to work correctly on the add and edit Editor modal forms. However, if I enter 123.45, the request payload sent to the server looks like this:
data[row_148300][Promotion][BundlePrice]: 12345So, 12345 (no decimal point) gets inserted into the database instead of 123.45. The next time I load the page, DataTables and the Editor forms show 12345.00
In the Chrome developer tools console, if I enter
$('#DTE_Field_Promotion-BundlePrice').val();, it returns '123.45', so I think the problem is in DataTables and not the jQuery masked input plugin.The problem appears to be in the recommended JavaScript we're to include, as show on this page of the documentation:
https://editor.datatables.net/plug-ins/field-type/editor.mask
get: function (conf) {return conf._input.cleanVal();},The
cleanVal()function returns the user's input with the decimal point stripped away. I'm not sure where thecleanValfunction resides or how it's supposed to work, but it seems like removing the decimal point is at odds with the idea of using a masked input in the first place.I believe I found the solution. Replacing
cleanVal()withval()returns the correctly formatted value.// return conf._input.cleanVal();return conf._input.val();Are there any downsides to using
val()instead?cleanVal()is a method of the Mask library.I think the only downside with using
val()instead would be that you might get the masking characters - but numeric validation would catch that.Given that it goes as far as stripping decimal points out, I reckon I'll change the plug-in to using
val().Thanks,
Allan