Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

View entries from multiple tables at once

Topic Labels: Views
Solved
Jump to Solution
516 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a small farm and use Airtable to track the animals. I have a table for their basic info (name, dob, etc), one for weights (used every time we weight them), one for any treatment(s) they get, and one to track breedings.

I’d like to be able to have a view where I can pull up an animal by name, then see all the other associated records regarding it from the other tables.

If I pull up animal “Bob,” I’d like to then see his weights and treatments in the same view (by most recent). I’ve tried searching these forums and the web to see if it’s possible, but have come up empty.

This view would normally be used from a mobile device.

1 Solution

Accepted Solutions

Welcome to the Airtable community.

You can use rollup and/or lookup fields to see information in linked records. The order of the information in the rollup/lookup fields will match the order of the linked record fields. Normally new linked records are added to the end of the list, so the data will not have the most recent information first. However, it is possible to reorder the linked records either manually or automatically (if the base is in a pro workspace).

See Solution in Thread

1 Reply 1

Welcome to the Airtable community.

You can use rollup and/or lookup fields to see information in linked records. The order of the information in the rollup/lookup fields will match the order of the linked record fields. Normally new linked records are added to the end of the list, so the data will not have the most recent information first. However, it is possible to reorder the linked records either manually or automatically (if the base is in a pro workspace).