How to get data from last related record

[Szymon_Hajduk]

I have two tables:

Proceses
Tunel - is ref to Tunels
Status - (text)

Tunels
Tunel (text)
Status (app fromula?)

so One to Many
One Tunel have many Proceses.

I want to see actuall Status of Process that is in Tunel
What I need is formula in Table: Tunels column Status that will get data from last record that is related to Proceses

[Jeremy_F · Accepted solution]

To get the status of the last process related to a specific tunnel, use this formula

Lookup( MAX(Select(Process[_RowNumber], [Tunnel] = [_ThisRow].[Tunnel] )) , “Process”, “_RowNumber”, “Status” )

Check out the guide on using lookup

help.appsheet.com

LOOKUP()

Get column value from row in table or slice