How to use MAXROW with Related List instead of the Table ?

AppSheet AppSheet Q&A
1

How to get MAXROW from Related List instead of the Table ?
I tried this but doesn’t work

Maxrow([Related Dies], “_rownumber”)

2

You can’t use MAXROW() for that. This should be equivalent:

ANY(
  ORDERBY(
    [Related Dies],
    [_ROWNUMBER],
      true
  )
)
4 Likes
3

Can we use time stamp instead of row number?

1 Like
4

Thanks Steve but this will choose a random value instead of the one with maximum row number. I want the row with maximum row number (the latest one) .

5

Wrong.

6

Yes, you can use a time stamp instead of the row number.

1 Like
7

@Steve I am using the following expression to arrange a different table in order to fetch the last value. unfortunately, it says (ORDERBY has invalid inputs). Am i writing it wrong?

ANY(
		ORDERBY(
    		Submittal RevNo[Rev],
        Submittal RevNo[_RowNumber],
        TRUE
    )

)
8 
ANY(
  ORDERBY(
    Submittal RevNo[Rev],
    [_RowNumber],
      TRUE
  )
)
9

Still giving (ORDERBY has invalid inputs) :disappointed_face:

10

https://help.appsheet.com/en/articles/2357312-orderby

11

Thank you. It is comprehensive :folded_hands:

1 Like