Actually this forum post may answer my question:
So I think what you are asking is …
“Do I have to redo all those calculations across multiple tables each time I update something” ?
The answer is probably “yes”. There is no way to have the database automatically update itself, or at least that I know of.
What you can do is have a one custom workflow that rejigs everything. And you could run this “in the background” so to speak.
So you wouldn’t need to do it on every page. You could have a single “function”.
You could schedule this to run …
In my case, every workflow that updates the Projects table would set a flag on the Location record, which would then trigger a workflow to update that record.
Forum
Academy
Marketplace
Showcase
Pricing
Features