Column Validation

[nishanParticipant]

Hi,

In my project I need to restrict the user to enter only alphanumeric with underscore in one column of my grid. If they enter any other characters it should not appear in the cell. How can I attain this in jqwidgets grid?

[DimitarParticipant]

Hello nishan,

You can bind to the editor’s keydown event in the column’s createeditor callback function. In the keydown event handler check if the entered character is valid and return false if not.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[nishanParticipant]

Hello Dimitar,

Thank you for your timely response. Can you please provide the snippet of code for handling the keydown event in create editor or an example for the same?

Regards,
Nisha

[DimitarParticipant]

Hi Nisha,

Here is an example column definition:

columns: [
    { text: 'First Name', columntype: 'textbox', datafield: 'firstname', width: 120,
        createeditor: function (row, cellvalue, editor) {
            var regex = new RegExp(/\w/);
            editor.keydown(function (event) {
                var char = event.char;
                if (!regex.test(char)) {
                    event.preventDefault();
                }
            });
        }
    },

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[nishanParticipant]

Thank you Dimitar. It is working as expected.

[Author]

Posts