Intersoft Community - WebGrid Enterprise - How to limit entry in WebGrid to a range of decimal values?

How to limit entry in WebGrid to a range of decimal values?

Hans — Wed, 30 May 2012 23:26:53 GMT

Hello,

You could use “OnDirty” client side event in WebInput.
However, you should use “setTimeout” function in that event.
Here’s the example snippet code, how to use “OnDirty” event:

function WebInput1_OnDirty(controlId, dirtySourceType) {
    var WebInput1 = ISGetObject(controlId);
    window.setTimeout(function () { Validate(WebInput1.GetValueData(true)); }, 300);
    return true;
}

function Validate(value) {
    // your validation
}

Hope this helps.
Thank you.
Regards,
Hans.

How to limit entry in WebGrid to a range of decimal values?

qafrank1 — Wed, 30 May 2012 09:57:45 GMT

Is there a way to place a range checker on the WebInput control?

If it should be handled the same, what function would I override ? Is there a corresponding "OnAfterExitEditMode" for WebInput?

How to limit entry in WebGrid to a range of decimal values?

Hans — Thu, 24 May 2012 21:51:55 GMT

Hello,

Yes, you could use this code. However, you should modify this code (the validation) according to your needs.

I try to make an edit and leave the cell without making any changes, by using example project that I’ve gave to you in earlier post.
But unfortunately, the value didn’t turn into “null”.

Would you mind to tell me how to replicate this issue? There may be a setting that I miss, in my example project.

Thank you.
Regards,
Hans.

How to limit entry in WebGrid to a range of decimal values?

qafrank1 — Thu, 24 May 2012 18:07:07 GMT

So, if I am using a grid with 6 different columns containing decimal types (currency), I need to write this code to handle culture settings?

Also, when I "click-into" the cell to make an edit, then leave the cell without entering a change, the value is "null" - not the value that was originally in the cell. Why?

How to limit entry in WebGrid to a range of decimal values?

Hans — Wed, 23 May 2012 22:19:47 GMT

Hello,

To resolve this issue, please replace the code in OnAfterExitEditMode to this code below:

function WebGrid1_OnAfterExitEditMode(controlId, tableName, editObject) {
    var WebGrid1 = ISGetObject(controlId);
    var ColumnName = editObject.ToCellObject().Name;

    if (ColumnName == "UnitPrice") {
        var TextPrice = editObject.element.value;
        var IntPrice = parseFloat(TextPrice);
        if (IntPrice >= 100 || IntPrice < 0) {

            editObject.ToCellObject().SetText("0", true);
            editObject.ToCellObject().SetValue("0");
            alert("Invalid UnitPrice Value");
            return false;
        }
        else {
            editObject.ToCellObject().SetText(TextPrice.toString(), true);
            editObject.ToCellObject().SetValue(TextPrice.toString());
            return true;
        }
    }
}

Hope this helps. Thank you.
Regards,
Hans.

How to limit entry in WebGrid to a range of decimal values?

qafrank1 — Wed, 23 May 2012 10:26:01 GMT

I have a need to change the culture sometimes.

In my example, if I change a value to "19,32", the grid changes it to "0". The javascript sees the value as "1932". How do I get this to work for an alternative culture? I still want the value to be saved to the database as "19.32".

Thanks.

How to limit entry in WebGrid to a range of decimal values?

Hans — Tue, 22 May 2012 23:51:23 GMT

Hello,

To apply this scenario, you should set DataFormatString to “##.##” and do some validation using OnAfterExitEditMode client side event.
I’ve made a sample project that similar with this scenario.
In my sample, I use Northwind.mdb database and Products table. Then, at UnitPrice column, I set DataFormatString to “##.##”.

And here the validation code in WebGrid’s OnAfterExitEditMode event:

function WebGrid1_OnAfterExitEditMode(controlId, tableName, editObject) {
    var WebGrid1 = ISGetObject(controlId);
    var ColumnName = editObject.ToCellObject().Name;
    if (ColumnName == "UnitPrice") {
        var TextPrice = editObject.ToCellObject().Text;
        var IntPrice = parseInt(TextPrice);
        if (IntPrice >= 100 || IntPrice < 0) {
            editObject.ToCellObject().SetText("0");
            editObject.ToCellObject().SetValue("0");
            alert("Invalid UnitPrice Value");
            return false;
        }
        else {
            return true;
        }
    }
}

I attached my sample as well, in order to make you easily understand about my sample.

Thank you.
Regards,
Hans.

How to limit entry in WebGrid to a range of decimal values?

qafrank1 — Tue, 22 May 2012 18:11:19 GMT

How can I define a range of acceptable values for data entry in the WebGrid? I want to limit both value and number of digits before and/or after the decimal.

For example, I want to limit the data to values between 0.00 and 99.99 for a field.

129.99 would not be acceptable
99.9043 would not be acceptable
0.003 would not be acceptable
0.34 would be acceptable
33.36 would be acceptable

Thanks.