Capture the value of the date column, of the last record, according to the id

[SoporteCompu]

I have my payment records that are stored in a table, which have the following columns; id, amount, date

I need to capture the value of the date of the last entered record, in a column of another table, according to the id.

[Marc_Dillon]

SoporteCompu:

I need to capture the value of the date of the last entered record

LOOKUP(
  MAXROW( payments-table , "_RowNumber" ) ,
  payments-table ,
  key-column ,
  date
)

SoporteCompu:

according to the id.

No idea what this part is supposed to mean.

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

help.appsheet.com

MAXROW()

Row with greatest value in column

[SoporteCompu]

Thank you so much.