Aggregate related records

nate 11 months ago updated by Dineshkumar Sivakumar 9 months ago 1

Looking for a way to show aggregates (sum) of related (1:N) records on the parent form.

For example, in a 1:N of Project -> Task, where Task has field taskBudget, you could display sum(taskBudget) on the Project form. 

I'd also like to handle multiple levels of 1:N (otherwise a rollup field might suffice). For example Project->Task->Subtask, and show sum(subtaskBudget) on Project form.

A plugin would be able to cater this request. but what is the need of a control or can you please elaborate more on your idea like what kind of control you are looking for visually.