Get most recent entry from referenced app in calculation field

Follow

Omar Bahra

• August 04, 2015 13:53

Hello,
I have a master app when i have product details and an other app where i store history of orders related to each product.
Using the calculation field in the master app you can easily show the sum, avg, or max values from the orders app but i want to show the quantity from the most recent order

the problem is when you reference an other app in the calculation field you get an array "@All of Quantity" ,where quantity is field in the orders app,this array contains integer values. if i can get an array of objects then i can probably use javascript to sort those objects based on date field and get the first element

Can anyone think of a way to do that ?

0

• 

  Rainer Grabowski

  • August 04, 2015 14:53

  Hi Omar,

  the latest related Order (= last element in the array) you get with:

  @all of Quantity[@all of Quantity.length-1]
  

  The oldest you get with:

  @all of Quantity[0]
  

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink
• 

  Omar Bahra

  • August 04, 2015 19:39

  That doesn't really work because the order in the array is based on the order you added the item in
  so if you add item 1 then 2 then then @all of Quantity[@all of Quantity.length-1] = 2
  but if you add 2 then 1 then @all of Quantity[@all of Quantity.length-1]=1
  what i'm looking for is that in the order history i have date field and i want to return the most recent order regardless what was the order they were added in

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 04, 2015 22:07

  This should work:

  var allDate = @all of datefield;
  var maxDate = moment(@max of date).format("YYYYMMDDhhmm");
  var quant = @all of quantity;
  
  result = 0;
  for(var i = 0; i < allDate.length; i++){
  if(moment(allDate[i].format("YYYYMMDDhhmm") == maxDate){
  result +=quant[i]
  }
  };
  

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink
• 

  Omar Bahra

  • August 05, 2015 13:44

  Thank you Rainer, that was really helpful

  0

  Comment actions Permalink
• 

  Tiago Lopes de Azevedo

  • April 23, 2019 13:06

  I get "unexpected token { " with last post... Can someone help?

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • April 23, 2019 18:55

  Add a screenshot and a copy of your calculation code, please.

  Rainer

  0

  Comment actions Permalink
• 

  Tiago Lopes de Azevedo

  • April 24, 2019 16:50

  Here it goes! Thanks a lot!

   

  

  0

  Comment actions Permalink
• 

  Omar Bahra

  • April 24, 2019 20:29

  You are missing a ) at the end of the if statement before the {

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • April 27, 2019 07:26

  There's indeed a missing closing ), but not at the end of the if, but behind allDate[i] (before .format() ).

  The date in the moment() function must always be wrapped in brackets before further operations (like .format()).

  Rainer

  0

  Comment actions Permalink
• 

  Simon Midtgaard Guldberg

  • March 29, 2022 09:12

  So, the above from Rainer finds the index of allDate that has the maximum date.

  Now, how to proceed from there to find the index of allDate with the second highest date?

  splice?

  0

  Comment actions Permalink

Please sign in to leave a comment.