4 Replies Latest reply on Mar 4, 2014 8:05 AM by DavidJondreau

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

    benlevi

      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?