No matter what I try, Airtable will not allow me to display a latest linked record in the primary field. All attempts end with circular reference errors. Table structure:
Company
name < primary, formula > ( {current name} )
company names [1:n] < linked > related to Company Name
current name < conditional lookup > from {company names} ( {if latest} = 1 )
...
Company Name
name < text >
company [n:1] < linked field > related to Company
if latest < formula > ( IF {start date} = {latest start date}, TRUE() )
...
I’m running out of ideas. As soon as I use company names in conditional context with if latest, I don’t get the value into the primary field. It also doesn’t matter if I evaluate current name in the Company table as shown in the example or in the Company Name table and use a normal unconditional lookup.
It can’t be that you have to use an automation for such a trivial thing!?
I would be happy if someone knows a solution.
