Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to lookup a text field inside a linked record's linked field?

Topic Labels: Base design
253 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi!

So I have a linked record in my table ‘Communiques’ to a record from (‘Contacts’) and I have a lookup field for that record’s Account field - which is a linked record to the Account table. In the Account table I have a text field for ‘Website’. What I would like to do is show this ‘Website’ record in my ‘Communiques’ table.

Hope that makes sense!

You can see a video of what I mean below:

Thanks a lot!

1 Reply 1

The [Contacts] table needs a Lookup-field for the [Account]'s {Website} field.

Your {Website} field in your [Communiques] table would be a Lookup field that looks up the value of [Contact]'s Lookup field.