Can a data field within a data type be an always current sum of other data fields?

Need help Database
1

Is there a way I can have a DATA FIELD always be the SUM of multiple other DATA FIELDS?
Let’s say I have one user in the USER data type and 3 businesses in the BUSINESS data type.
I want to have a DATA FIELD called TOTAL in the USER data type which is the SUM of all totals from each of the businesses TOTALs. :wink:
(At this point I realize this is confusing. I will create a spreadsheet)

image
image1119×441 9.55 KB

Thank you

2

You can do that with Triggers in the backend workflow section. Just say thing before change field:count is not thing now field:count then make changes to thing now. Field Total = field:count