columns for quantity, price, subtotal

boudga

How would I add columns to my existing datatables data coming from the database that would be for me to input quantity, price, and when i added those two would reflect a subtotal in the third column?

I am kind of wanting to make a table based invoice of sorts

allan

Editor will let you input the data, and then use a renderer to calculate the third data point from the other two.

Allan

boudga

i added a column like this:

{"data": null, "defaultContent": "0.00"}

boudga

Can you please provide an example?

allan

Of the renderer?

data: null,
render: function (data, type, row) {
  return data.quantity * data.price;
}

(assuming you are using objects that have quantity and price properties).

Allan