kendo grid cell validation for 2 decimal places

Question

I have a kendo grid that needs to display discounts.I have to implement the validation that it should accept numbers between 0.00 and 100. I have written code for accepting numbers between 0 and 100, now i need to implement the 2 decimal place validation as well. Please help.

$(gridname).kendoGrid({
        dataSource: {
            data: data.ReportData,
            schema: {
                model: {
                    fields: {
                        ProposedDiscountNST: {format: "{0:n2}",
                            validation: {
                                required: true,
                                proposeddiscountNSTvalidation: function (input) {
                                    if (input.val() != "" && input.is("[name='ProposedDiscountNST']")) {
                                        input.attr("data-proposeddiscountNSTvalidation-msg", "Should be between 0.00 & 100");

                                     //   return input.val() >= 0 && input.val() < 101 && input.val() % 1 == 0;
                                        return input.val() >= 0 && input.val() < 101 ;   // Accepts max 2 decimal digits
                                    } else {
                                        return true;
                                    }
                                }
                            }
                        }

I need to display the validation message that this field accepts 2 decimal places only. Please help.

score 0 · Answer 1 · answered Oct 30 '18 at 07:30

0

How to obtain the number of decimals is described in multiple places, e.g. Simplest way of getting the number of decimals in a number in JavaScript Get this number and check if is okay or not.

One remark: You are checking if input.val() < 101 This includes 100.7 and does not seem match your requirement "between 0.00 and 100".

answered Oct 30 '18 at 07:30

Carsten Franke

1,649
2
13
30

Yes i changed it to <= 100. Thanks for the help. – Tannya Oct 30 '18 at 08:37
If that or any other reply answered your question, please mark it as "accepted". Other users may find the most helpful and relevant answer faster that way. – Carsten Franke Oct 30 '18 at 11:24

Stephan T. · Answer 2 · 2018-10-30T08:06:25.700

You can get the number of decimals by comparing the number and the fixed number (number.toFixed(x) rounds the given number to x decimals):

$(gridname).kendoGrid({
    dataSource: {
        data: data.ReportData,
        schema: {
            model: {
                fields: {
                    ProposedDiscountNST: {format: "{0:n2}",
                        validation: {
                            required: true,
                            proposeddiscountNSTvalidation: function (input) {
                                if (input.val() != "" && input.is("[name='ProposedDiscountNST']")) {
                                    input.attr(
                                        "data-proposeddiscountNSTvalidation-msg", 
                                        "Value should be between 0.00 & 100 and have a maximum of 2 decimals"
                                    );
                                    return 
                                            input.val() >= 0 && 
                                            input.val() <= 100 &&
                                            input.val() == input.val().toFixed(2)
                                    ; 
                                } else {
                                    return true;
                                }
                            }
                        }
                    }
                }
            }
        }
    }
});

Thanks for the reply but it didn't show the error message in the screen. — Tannya, Oct 30 '18 at 08:39

score -1 · Answer 3 · answered Oct 30 '18 at 08:36

Actually I tried the above solution by Stephan T. but unfortunately it did not work. so I tried this method and it worked. So posting it so that it will help some one.

$(gridname).kendoGrid({

        dataSource: {
            data: data.ReportData,
            schema: {
                model: {
                    fields: {
                        ProposedDiscountNST: {format: "{0:n2}",
                            validation: {
                                required: true,
                                proposeddiscountNSTvalidation: function (input) {
                                    if (input.val() != "" && input.is("[name='ProposedDiscountNST']")) {
                                        input.attr("data-proposeddiscountNSTvalidation-msg", "Should be between 0.00 & 100");

                                     //   return input.val() >= 0 && input.val() < 101 && input.val() % 1 == 0;
                                        return input.val() >= 0 && input.val() <= 100 && ((parseFloat(input.val()) / (parseFloat(input.val()).toFixed(2))) == 1 );   // Accepts max 2 decimal digits

                                    } else {
                                        return true;
                                    }
                                }
                            }
                        }

kendo grid cell validation for 2 decimal places

3 Answers3