I have a Column Changed event that sends the ReqDetail dataview to a function. This works, but my function has the old data from the dataview instead of the new values. How do I get this to trigger once the dataview update is complete?
Use %value%
instead of {DataView.Column}
.
Thanks, so %value% will get me the proposed value of the changed column, correct?
What I am looking to do is get a total of all the requisition lines. My thought was to use the column changed trigger on the DocUnitCost column and then send the ReqDetail dataview to a function. Also tried passing just the ReqNum to a function but seems to be a timing issue with the Column Changed trigger.
Is there a different way to trigger this event after the column change has completed?
Yes.
Honestly, I would just use a BPM and forgo App Studio for this one.
Req.GetCostInfoExt fires when the unit cost changes. Do a calculation there and either display it in a UD field for permanence or in a call context field for temp.
You’d need one on GetByID as well to get the cost when opening a record.
That way, in App Studio, you only need to display the field.