Update value issues on detail view

CHRISTOPHE_CHAN · 01-27-2020 02:35 AM

Hi,

I have an issue with update on a detail view. Sometimes working, sometimes not. I want the value of the colums Prévision Heure to be updated on the detail view. As on capture, it is not working. The formula seems to be working as the column is OK on capture 6. Any idea ?

Steve

I’m afraid I don’t understand the problem. Can you try stating it a different way, perhaps with more details?

CHRISTOPHE_CHAN

Ok no problem I try to precise it. I have a detail view (chantier) with a column called Prevision heure. Prevision heure is a sum of the quantity column of several Main d’oeuvre ( which are records related to Chantier). When I add or delete or édit a Main d’oeuvre record, the Prevision heure column is correctly updating on the Chantier form. I assume the sum formula is ok. But on the Chantier detail view, on which I chose to show the Prevision heure value, the value is not updating correctly. Am I clear enough ?

Steve

Does the Prevision heure value eventually update, after a sync?

CHRISTOPHE_CHAN

It doesn’t here is the point

Steve

Is Prevision heure a virtual column, or a normal column?

CHRISTOPHE_CHAN

Hi Steve, it’s an normal one.

Steve

Ah, that’s the problem. Normal column app formulas are only recalculated when the row containing the column is itself updated; the normal column’s app formula is not recalculated when data it uses outside its row changes. To achieve a responsive update, you will either need to change the normal column to a virtual column (easier), or use actions and possibly workflows to update the normal column when the child rows change (much harder).