Intersoft Community - WebGrid Enterprise - Use Enter key to add new row

Use Enter key to add new row

hohenbergerc — Tue, 02 Feb 2010 10:55:41 GMT

Andi,

After spending time looking at the documentation for WebGrid on http://support.intersoftpt.com/, I discovered some code to 'Reconfigure the "Enter" key functions on EditMode'. I was able to add the following section and make it work for Adding also. I've attached the code for reference.

Thanks for your help!

Conrad

function WebGrid1_OnEditKeyDown(controlId) {if (event.keyCode == 13) {//cancel the event as it'll be handled manually event.returnValue = false;var grid = ISGetObject("WebGrid1");//get currently active edit cell var ac = grid.GetActiveEditCell();if (ac.rowElement.type == "Record") {//get the table object var tbl = grid.Tables[ac.tblName];grid.ExitEdit(1, 0, 0) // exit and update the row if dirty //find out if the table of current row is parent var isParent = (tbl.GetChildTables().length > 0) ? true : false;window.setTimeout(function() { SelectNext(ac, isParent); }, 500);//you can try to remove this line if you receive a javascript error return false;

}

if (ac.rowElement.type == "NewRow") {//get the table object var tbl = grid.Tables[ac.tblName];grid.ExitEdit(1, 0, 0) // exit and update the row if dirty //find out if the table of current row is parent var isParent = (tbl.GetChildTables().length > 0) ? true : false;window.setTimeout(function() { SelectNext(ac, isParent); }, 500);//you can try to remove this line if you receive a javascript error return false;

}

return true;

}

function SelectNext(ac, isParent) {var curRow = ac.rowElement;var tblElm = wgGetTable(curRow);var curRowIndex = curRow.rowIndex;//if a table is a parent, the index numbering increases by 2 var i = (isParent) ? 2 : 1;//check if current row is the last row of the table if (curRowIndex < tblElm.rows.length - i) {//get destination now var destRow = wgGetRowByPosition(tblElm, curRowIndex + i);//highlight the destination row //wgHighlightROw(destRow); //get the column name var cellName = wgGetColNameByCell(ac.element);//get the destination cell var destCell = wgGetCellByName(destRow, cellName);//select nextRow and highlight the destination cell window.setTimeout(function() { MoveRow(destRow, destCell); }, 500);

}

function MoveRow(destRow, destCell) {

wgGetRowByElement(destRow).Select();

wgHighlightEditCell(destCell);

}

Use Enter key to add new row

hohenbergerc — Tue, 02 Feb 2010 08:18:14 GMT

Andi,

Your example works as expected. I've stumbled upon some new information. When I get the null object error message with my code, it references the previous page, not the page containing the control. Does this offer any clues to my problem?

Thanks,

Conrad

Use Enter key to add new row

andi@intersoftpt.com — Mon, 01 Feb 2010 21:13:10 GMT

Hi Conrad,

Yes, forgive me for miss that point. The problem is occured because when we try to access to the next new column, there exists a delay. That is why we need to set time out when we try to access it. Using this code should be solved the issue.

setTimeout(function() { GetRow.GetCells()[position].Select(); }, 200)

I hope it helps and please do not hesitate to ask if you have any other questions. Thank you.

Best Regards,

Andi Santoso

Use Enter key to add new row

hohenbergerc — Mon, 01 Feb 2010 08:08:10 GMT

Andi,

The first 3 columns seem to work and then I get this message on the 4th column. As I stated earlier, the KeyDown event works if I hit the Enter key twice. Does that offer any clues?

Thanks,

Conrad

Use Enter key to add new row

andi@intersoftpt.com — Sun, 31 Jan 2010 21:13:39 GMT

Hi Conrad,

In your case, it seems that the object is null. Here, I attached a simple running sample that using "Enter" as a "Tab" button in adding new row on WebGrid. Would you kindly try to run my sample and see if the issue is still occurred. My sample is using Northwind Customer database.

I hope it helps and please let me know if the error is still occurred. Thank you.

Best Regards,

Andi Santoso

Use Enter key to add new row

hohenbergerc — Fri, 29 Jan 2010 08:29:52 GMT

Andi,

Using the code above, I receive the error message attached.

Thanks,

Conrad

Use Enter key to add new row

andi@intersoftpt.com — Thu, 28 Jan 2010 23:49:36 GMT

Hi Conrad,

Here is the sample code to use Enter key as a Tab key when we are adding a new row in WebGrid. In here, I am still using OnEditKeyDown. Here is the snippet:

 function WebGrid1_OnEditKeyDown(controlId) {
            var WebGrid1 = ISGetObject(controlId);
            var position = WebGrid1.GetActiveEditCell().cellIndex;
           
            if (event.keyCode == 13) {
                WebGrid1.GetActiveEditCell().ToCellObject().GetRow().GetCells()[position].Se                lect();
            }
            return true;
        }

I hope it helps and please, do not hesitate to ask if you have any other questions. Thank you.

Best Regards,

Andi Santoso

Use Enter key to add new row

hohenbergerc — Thu, 28 Jan 2010 11:27:42 GMT

I'm attempting to use the following code to enable the enter key to work as a tab to add a new row to the grid:

function HandleKeyDown(gridId) { var grid = ISGetObject(gridId);

var ac = grid.getActiveEditCell();

if (ac.rowElement.type == "NewRow") { if (event.keyCode == 13) // If Enter key is pressed event.keyCode = 9; // change it to Tab

}

return true; // continue default processing.

}

If I assign it to OnEditKeyDown, I get an error (see attached). If I assign it to OnKeyDown, I must press the enter key twice to add the row.

Any help would be greatly appreciated.