Intersoft Community - WebGrid Enterprise - How-to: Calculate a cell after a value is filled

How-to: Calculate a cell after a value is filled

Glayaar — Mon, 22 Mar 2010 22:41:08 GMT

In my test, the column must be a bound column in order to set the text correctly. A workaround for your scenario would be modify the select query to include the Percentage Hours, for example

SELECT ID, StandardHours, DirectHours, '' AS PercentageHours
FROM Hours

Initially you could use the InitializeRow server side event in order to fill the percentage hours cell.

Attached is the demonstration of the workaround.

How-to: Calculate a cell after a value is filled

bdenison — Mon, 22 Mar 2010 11:04:40 GMT

No it's an unbound column. since the Standard Hours and the Direct Hours are stored in the database, there is no need to store the percentage. I just need the calculation change to appear in another column after any changes to the other two fields. I assume I will need to have the same calc for the initialization of the grid.

Are there any settings that need to be set on the grid or column property in order for unbound columns to appear? Do I need to switch from server side binding to client side binding?

How-to: Calculate a cell after a value is filled

Glayaar — Mon, 22 Mar 2010 03:47:23 GMT

My test show that using the snippet you provided will allow us to update the DirectPct column correctly. The test will displayed the updated DirectPct value correctly in the WebGrid. The test is already using the latest WebGrid 7 build and WebUI Framework 3, build 402 and build 752

Does the update you meant in your post is the update process to the database?

How-to: Calculate a cell after a value is filled

bdenison — Mon, 22 Mar 2010 00:04:47 GMT

I am trying use this example to get an Excel like ability for a grid. The code calculates correctly, and there are no errors. However the grid cell does not update? is there something I am missing?

function WebGridDetail_OnExitEditMode(controlId, tblName, editObject) { var grd = ISGetObject(controlId); var cell = wgGetCellByElement(editObject.cellElement); var colName = cell.Name; if (colName == "DirectHours") { var row = cell.Row; var stdhours = parseFloat(row.GetCells().GetNamedItem("StandardHours").Text); var dirhours = parseFloat(editObject.element.value); if (stdhours == 0) {

result = 0;

}

else {

result = dirhours/stdhours * 100;

}

row.GetCells().GetNamedItem("DirectPct").SetText(String(result), true);