MAXROW-related question. I realize that MAXRO...

(Joseph Pentheroudakis) #1

MAXROW-related question. I realize that MAXROW returns the row with the highest value in the column specified in the second parameter. So. MAXROW(Runs,Date), in my case, returns the row in the Runs table with the most recent date. (Great description of the function here, by the way: https://plus.google.com/109264770281245493545/posts/GFX5y9anv5Z)

Ok, so how do I go about accessing one of the columns in that row? Say Runs had four columns, A, B, C, and D. How do I get the value of column C in that maxrow?

Thank you!

(Tony Fader) #2

@Charlie_Wells Put your MAXROW into the app formula of virtual column called “Most recent run”. Then you can access columns like so: [Most recent run].[A]

https://www.appsheet.com/samples/Initialize-forms-with-most-recent-value?appGuidString=18b39921-b8a8-46f4-b419-2acbf067ba08

(Joseph Pentheroudakis) #3

@tony

Simply beautiful and very elegant. Thank you! I am head over heels in love with this tool; you guys are great.