This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Nested Lookups (a lookup within a lookup of a linked field)

Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I think being able to lookup within a lookup of a linked field would be quite useful. For example, I have three tables: “Projects”, “Shipments”, and “Clients”. There can be multiple projects per client, and there can multiple shipments per project. I want to display the Client contact information on the “Shipments” table, but as the client name auto-populates using a lookup field, which pulls the name from a linked field on the “Projects” table, I cannot look within this lookup of a linked field. I can only get the desired result if I re-enter the Client data on the “Shipments” table via a linked field directly to the “Client” table, which is not only tedious but leaves room for error.

If anyone knows of a better way to do this, please let me know. If anyone from Airtable can add this functionality, it would also be great.

1 Comment
4 - Data Explorer
4 - Data Explorer

I’m having the same type of problem.

@Aaron did you find a solution by any chance?