How do I format a grid cell based on its value compared to another cell?

[AkAlan]

I want to compare a column (QtyReceived) to another column (QtyShipped) and change the background color of the QtyReceived column if it is less than QtyShipped. I need to be able to do the compare when the grid is first fired then after the user edits the QtyReceived column.

[Pechka]

Hi,

What kind of binding do you use? 

[AkAlan]

I'm using Ajax binding. Here is the code within my View:

.DataSource(dataSource => dataSource

                       .Ajax()

                       .Model(model => model.Id(p => p.ID))

                       .Batch(true)

                       .ServerOperation(false)

                       .Read(read => read.Action("Editing_Read", "Shipping"))

                       .Update(update => update.Action("Editing_Update", "Shipping"))

                       .Destroy(update => update.Action("Editing_Destroy", "Shipping"))

                   )

[Pechka]

Hi,

Currently I you can achieve this easily with a template columns. Here is a similar scenario like this:

.Columns(columns =>

{

    columns.Bound(c => c.SomeVal);

    columns.Bound(c => c.Name).ClientTemplate("#= getFormat(SomeVal,Name)#");

})

and the following function which will handle the formatting:

function getFormat (val,name) {

        if (val> 10) {

            return name;

        }

        else {

            return "<div style='background:red'> "+ name +" </div>"

        }

    }