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.
Solved! Go to Solution.
Try MAXROW("Table1","Date",[Firm]=[_THISROW].[Firm])
https://support.google.com/appsheet/answer/10107920?hl=en&sjid=1123221503251865878-EU
Try MAXROW("Table1","Date",[Firm]=[_THISROW].[Firm])
https://support.google.com/appsheet/answer/10107920?hl=en&sjid=1123221503251865878-EU
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.
Thank you
No problem ๐
So does it work now?
Sorry for my english.
I did not fix it
What are your column types for table1_id and col3?
I set both text column, but col3 switch into ref
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?
Into formula field. I need that col3 changes every time when table1_id change.
And when you open that record from table2, what that formula shows? Or is it just a blank?
https://app.screencast.com/gkURjP7MgySXe
Operare Lunara = Table1
Terminat = Date
Firma = Firm
Denumire Firma - Firm
Luna Operata - Col3
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?
Your source table is wrong. It should be "Operare Lunara ".
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |