Related Items Sum

[jennifer_little]

Hi Dmitry,

I have created a few test lists to strip back what I was doing. I have attached the findings from running f12.

Thanks

Jennifer

[jennifer_little]

Please see the parent list with the project cost field and the child list with the costs that I want to add up.

Thanks

Jennifer

[Dmitry Kozlov]

Please, use the following code:

Code: Select all

var total = 0;
var rows = fd.relatedItems(0).data('ctx').ListData.Row;
rows.forEach(function(item) {
    total += parseFloat(item['Cost.'])
});
alert(total);

[jennifer_little]

Thanks! I got this to work in my sandbox. I am wanting to do the calculation on the Display Form. I can get the pop up with the total but when it comes to inputting the total into a field it doesn't work. Is this because its the Display View?

Thanks

[Dmitry Kozlov]

You cannot update a field in a Display form. But you can replace its display value:
fd.field('FieldName'),control()._el().html(calculatedValue);