Hello, I’m still trying to grab the latest comment from my discussion board that I’ve created on AppSheet and thought I got it, but guess I didn’t. I tried the following expression: INDEX(SORT(SELECT(commentsSection[Employee],([_THISROW]=[Comment Corner ID])),TRUE),1. However it doesn’t work correctly and doesn’t grab the most recent Employee. In the commensSection table I also have a Date and a Date/Time column, but don’t know how 2 use them in the expression to get the latest entry. Comment Corner ID is the ID to link to the commentsSection table to the Comment Corner table.
No worries I figured it out using another question on this board, man that’s a bit more complicated than I thought that u needed 2 do, but such is the beauty of learning AppSheet
1 Like
LOOKUP( MAXROW() )
2 Likes