i’m currently stuck with a seemingly simple problem:
- I have a list of “client” things
- Each “client” thing has a list of “project” things
- Each “project” thing has a “budget” field with a number in it
I just cannot figure out at the moment how to sum up all the “budget” fields within their respective lists at once.
Is there a realtime calculation method i’m not aware of? Or does the calculation needs to be done at the moment where a “project” thing with the respective “budget” value is being created?
I would like to use the resulting list as an input for datapoints of a line chart. Or a text field with a comma separated list containing the totals for each “project” list of things of each “client” thing.
Any help is very much appreciated, thank you!
I assume it somehow can be done together with the fabulous toolbox plugin from @mishav and some additional JS…Am i right? Maybe somebody faced a similar issue and can point me in the right direction? In the time being i stick to the hardcoded way, so never mind folks.