May 18, 201312 yr 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?
May 19, 201312 yr 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.
Create an account or sign in to comment