Trigger script after field value is committed

[mpau]

Is there a way to trigger a script after a (portal) field value is committed? All the script triggers seem to run before the value is committed and so any set fields or insert calculations steps refer to the prior field value, not the current, active value. 

 

For example, I have a standard invoice layout with line item records in a portal. On the invoice record is a subtotal field. It is not a calculation and so requires a script to update it. I'd like to update this field each time a unit price is changed.

 

Right now, I have it updated by using an OnObjectValidate script with the step Set Field (Invoice::Subtotal; Sum (Lineitem::UnitPriceExtended). For the subtotal field to accurately update, I have to run a commit record script step first. This works, but it's slow. Is there another way to do this? 

[Wim Decorte]

Check this reference for what triggers are pre and which one post:

 

http://www.filemakerhacks.com/?p=5333

 

 

That should help you decide which one to use in this case.