I have an inventory table that calculates an ...

(Marc Dillon) #1

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?

(Marc Dillon) #2

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.

(Reza Raoofi) #3

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?

(Marc Dillon) #4

Oh right. Yes that works, thanks!