Field updated by Custom Function not triggering workflow
Hi Team - I have a field that is updated by a custom function. I have a workflow rule that runs a custom function whenever that field is updated. Unfortunately, that workflow rule is not triggering. I even changed the workflow to Edit and run this rule whenever the record is edited but it is not triggering. It is not in the timeline.
The scenario is: when Deals stage is Invoiced in our blueprint, a custom function will fire off and update Last Order Date in Accounts. We need the Accounts record updated whenever the Last Order Date is updated. The corresponding Accounts workflow rule will fire off another custom function to recalculate Total Amount, Total Order, Average Amount, etc.
Is this a limitation where a field being updated by a custom function will not trigger a workflow rule?
Workaround I see is to built a custom function that will update everything needed when Deals is invoiced.