App formula for column in parent table only updates when that specific record is re-saved

[Peter_Mueller]

A column (Total Order Value) in a parent table (Customers) uses an app formula to sum up values in the child table (Orders) that are related to that customer. 

The values are only updating if I edit and save the Customer record. Is there a way for these to update whenever change is made in the Orders records?

Sorry if this is answered somewhere else.

[khuslid]

App Formulas within physical columns only refresh if the record is changed. If you need the physical column to recalculate, you will need to “trigger” that record with a data change.  You can do that with an action that is triggered by SAVE in a form or on UPDATES in a BOT.

[Peter_Mueller]

ok - thanks! I'll see if I can make that work.