Formula for ref table

[Madalin]

Hello. 
Please help me with a solution. I have 2 tables:

Table 1
tabel1_id (text)
firm (ref to Tabel2) (label)
Date (date)

Table 2
col1= tabel2_id (text)
col2=firm (text) (lable)
col3 = formula

Please help me with the formula needed to update the col3 value with the latest text1_id corresponding to the firm

For example

Table 1

tabel1_id	firm	date
Id1	XXXX ltd	01.12.2023
Id2	YYYY ltd	01.12.2023
Id3	XXXX ltd	12.12.2023
Id4	YYYY ltd	12.12.2023

 Table 2

Tabel2_id	firm	col3
Aa1	XXXX ltd	id3
Aa2	YYYY ltd	id4

When I had the registration on 01.12.2023 in table 2 in the data it appeared id1 and id2.
Thank you.

[AleksiAlkio · Accepted solution]

Try MAXROW("Table1","Date",[Firm]=[_THISROW].[Firm])
https://support.google.com/appsheet/answer/10107920?hl=en&sjid=1123221503251865878-EU

[Madalin]

Thank you for your help.

In col 3 I get table1 (0)

I try a lot of combination from https://support.google.com/appsheet/answer/10107920?hl=en&sjid=1123221503251865878-EU.

I did fix it.

[Madalin]

Thank you

[AleksiAlkio]

No problem 🙂

[AleksiAlkio]

So does it work now?

[Madalin]

Sorry for my english.

I did not fix it

[AleksiAlkio]

What are your column types for table1_id and col3?

[Madalin]

I set both text column, but col3 switch into ref

[AleksiAlkio]

That's normal if your column is a key column in table1. Do you have that formula in the initial value or app formula field?

[Madalin]

Into formula field. I need that col3 changes every time when table1_id change.

[AleksiAlkio]

And when you open that record from table2, what that formula shows? Or is it just a blank?

[Madalin]

https://app.screencast.com/gkURjP7MgySXe
Operare Lunara = Table1
Terminat = Date
Firma = Firm
Denumire Firma - Firm
Luna Operata - Col3

[AleksiAlkio]

Any chance your Firma and Denumire Firma are in an opposite order than they should be? Also.. is your "Luna Operata" referenced to the "Operare Lunara" table?

[Madalin]

https://app.screencast.com/RLQXvVV3BUxE8

https://app.screencast.com/Gl94RoCjVOyBj

[AleksiAlkio]

Your source table is wrong. It should be "Operare Lunara ".