I have an inventory table that calculates an ...

I have an inventory table that calculates an inventory value by summing up child records. I want to have a workflow rule that triggers when this calculated value is changed, which happens when a child record is added/deleted/editted.

Setting the target data to the child records gets the trigger to work, but the rule doesnโ€™t act on the parent records. Setting the target to the parent records makes the trigger not work. Any easy ways to make this work?

0 3 387
3 REPLIES 3

Iโ€™m thinking add a second workflow rule for the child records that updates a value in the parent records via an API call, which then triggers the parent record workflow rule. It should work, but that just seems overly complicated for a situation that feels like it should be pretty common.

RezaRaoofi
Participant V

Have you tried setting child table as workflowโ€™s target data to trigger when record is added/deleted/edited in child table, then accessing the calculated column from parent table using De-referencing?

Oh right. Yes that works, thanks!

Top Labels in this Space