Show calculation based on latest app entry.Answered
What can I use to display a result in one app, that only pulls the result from the latest entry in another app. Ie. I don't want max, min, average or sum. Rather I want it to display the latest entry over the one prior to this?
I have searched the forums and cannot find a solution to this? Have I missed something simple?
Your time to assist is much appreciated.
I assume that in App A (the one with the calculation field) is more then 1 item attached from App B.
If so you can use:
var a = @all of FieldNameInAppB a[a.length-1]
The function ".length" determines the quantity of all elements (items) of the array "all of FieldNameInAppB" (e.g. 42 items), but the first (=oldest) element has the number 0 and the last (= latest) has the number 41. So you have to substract 1 from the amount to get the latest one.
Hope it helps,
Please sign in to leave a comment.