I’m trying to pull the content of a linked column within a linked column into a table but cannot figure out how to do it. I will give an example to make it clearer what I mean.
I have a table 1 - this contains a list of items
I have a table 2 - items in here are linked to table 1 (they belong to a category listed in table 1)
I have a table 3 - items in here are again linked to an item (category) in table 2, which basically makes them a sub-category of table 1 by the link already established in table 2
Now using the formula field in table 3, I can pull the contents of columns from table 2 but this doesn’t work with linked columns from table 2 (the one that shows to which category from table 1 the item in table 3 belongs to). I desperately need to have this correlation established though.
Could you please point me in the right direction on how to achieve this. I think in Airtable it is called a ‘lookup’ field!?
Thanks in advance!
Edit: I tried to workaround by converting the linked field to a formula field in table 2 and reference to this one but that also doesn’t seem to work?!