Automation or Action to Update Parent Table when a Child Table is Added Updated or Deleted

[stephenrich]

Dear Appsheeters,

I found some problem when I create, update, or delete a child record, the Sum Related Child in the parent table wont Update.

It's like it did not trigger the calculation if i do not edit and save the parent.

Is there any solution to update parent table when a record in child table is added, updated, or deleted?

Many thanks.

[Suvrutt_Gurjar]

Please use reference actions in a data change bot on the child table.

In the example below the "order Details is a child table and Orders is the parent table.

Data Change bot on the child table "Order Details" ( Add , update, delete)

Create action type "Run Action on rows" that references the parent table "Orders" and the referenced rows are LIST([Order ID]) which is the reference column in the child table "order Details"

Create a referenced action "Total Cost Compute" on the parent table that computes the total order cost based on "add, delete or update" to the child table "Order Details"

The "Total Cost " is computed in the parent Orders table on each add, delete or update to the Order Details table. The expression in the action is SUM([Related Order Details][Total]) where [Total] is the cost of each line item in the child table

[stephenrich]

Dear Suvrutt,

Thank you for your kind advice.

I already did that before.

In the [Sales Quotation Details] table or the child table, i already made an action.

and in the Parent table [Sales Quotation] I also made the executing action like below:

and then, I create an automation in the child table [Sales Quotation Details]

to trigger this action below:

But it wont execute the updates on the parent table.

please advice.

thank you.

[Suvrutt_Gurjar]

Please test with  'Custom action" selected in the bot step in place of "U1 Update SQ"

[stephenrich]

I have. Previously i use this action and place it on my [Sales Quotation Detail] Form behaviour when Save. 

But I think i need to update [Sales Quotation] parent table not just when the [Sales Quotation Details] child table added, but when updated, and deleted. So that's why I also create an automation bot.

But somehow it did not triggered it properly.

And the weird part is, on the desktop version, my virtual column wont sum related child immediately even if i have deleted a child record.

Does this happened because of the slow sync? 

[Suvrutt_Gurjar]

Sorry, I am unable to understand the current status.  Understood that previously you had event action on form save and that you converted to bot.

Could you update if the bot runs properly now with the suggested changes?