AnsweredAssumed Answered

How to set a script trigger to fire when a calculation result changes

Question asked by benlevi on Mar 4, 2014
Latest reply on Mar 4, 2014 by DavidJondreau

I have an invoice table with a SUBTOTAL field that changes whenever an Invoice Line Item is changed. When that SUBTOTAL calculated field changes, I want to recalculate a SALES TAX field. So I tried to set up a script trigger on SUBTOTAL using "OnObjectModify" which should trigger the script to recalulate the SALES TAX field, but it doesn't work when the SUBTOTAL calculated field changes. I also tried using "OnObjectValidate" on the SUBTOTAL field, but that didn't work either. Note the user isn't manually entering the SUBTOTAL field, but it is changing nevertheless. Why isn't the script trigger firing?