Show calculation based on latest app entry.

Answered

Follow

Richard Barley

• February 27, 2015 09:29

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.

0

• 

  Rainer Grabowski (FVM)

  • February 27, 2015 12:23

  Hi Richard,
  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,
  Rainer
  rg@delos-consulting

  1

  Comment actions Permalink
• 

  Richard Barley

  • March 01, 2015 09:07

  Rainer - THANKYOU so much. That was exactly what was needed. Your prompt response was very much appreciated.

  0

  Comment actions Permalink
• 

  Mike Adams

  • April 20, 2015 11:56

  Great!!!! This also answers my question - i will update this answer on my request
  Thanks very much Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.