How can I select the most recent record from ...

(vicodu Odu) #1

How can I select the most recent record from a list?

(Suvrutt Gurjar) #2

@vicodu_Odu ,

For getting the reference to the most recently created record in the same table, please refer to MAXROW() function described in the article below. The function returns the "Key " of the most recently created record.

help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com

(Suvrutt Gurjar) #3

If you are looking to get the most recent child record from a child record in a parent table for each parent record , then please refer to the sample app below

appsheet.com - Most Recent Child Row - This app shows how to get the most recent related row for a table Most Recent Child Row - This app shows how to get the most recent related row for a table appsheet.com

(Steven Coile) #4

To get the row at the bottom of the spreadsheet, the row with the highest row number:

MAXROW(“TableName”, “_ROWNUMBER”)

replacing TableName with the name of your table.

If your table has a timestamp column (Timestamp), and you want the row with the most-recent timestamp:

MAXROW(“TableName”, “Timestamp”)

(vicodu Odu) #5

@Suvrutt_Gurjar

+Steve Coile

Awesome thanks