Help

View entries from multiple tables at once

Topic Labels: Views
Solved
Jump to Solution
1147 1
cancel
Showing results for 
Search instead for 
Did you mean: 
MKL
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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).