From changes on a table, trigger updates on columns with formula from another table

[Jonatan_Torino]

I apologize for my english.

I was googling but couldn’t find an answer to my problem.

I have a header table, with columns of calculated totals that add up to amounts from a child table.

Sales Header
-TotalOrder = SUM (SELECT (SalesLines [Subtotal], [SalesNo] = [_THISROW]. [SalesNo]))

Obviously, first I create a record in the header table which is written to my excel file. But when I enter a new line in the child table, I can’t get the calculated field “TotalOrder” to be refreshed. I have to open the form in edit mode for the header table and save to refresh the “TotalOrder” field. .

I tried to create an action for records in the header table, Data: set the values of some columns in this row, but it only shows me the fields that do NOT have a FORMULA.
Am I misusing the summation in the header?
Is there a way to trigger in another table an update of its fields with formula?

[Steve]

Instead of using App formula, use Initial value and enable Reset on edit?. Then the column will be available for the action.

[Jonatan_Torino · Accepted solution]

Sorry by my delay to thank you, i was a busy.

With “Reset on edit?” i solve my issue.
I share another setting needs for not allow input a value on TotalOrder field because its may cause a inconsistence.

I set TotalOrder to allow edit, put the SUM formula on initial value with the mark on “Reset on edit?”, and olso set the “Valid if” with LIST formula enclosing the SUM used on initial value. Olso check the “Require?” property, to ensure that always is persisted the value.

[marcomavil]

Hi. 

I, like many others, have the exact same problem.

Tried your solution but it did not worked. Maybe I'm doing something wrong 'couse even after puting the formula on initial value and mark "reset on edit" and setting the "valid if" value it only updates after I edit and save just like before...

Can you share more details on what you did to make it work?

Regards

[Viral]

I tried setting the SUM formula in Initial Value for TotalAmount field in Header Table. Also enabled Reset on Edit. Still when an amount in one of the item changes, it does not change the total amount in header. Your help would be much appreciated.

[Viral]

I tried setting the SUM formula in Initial Value. Also enabled Reset on Edit. Still when an amount in one of the item changes, it does not change the total amount in header. Your help would be much appreciated.

[Steve]

Please start a new topic for help with this.