Jun 08, 2021 05:03 AM
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.
Solved! Go to Solution.
Jun 08, 2021 09:54 AM
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).
Jun 08, 2021 09:54 AM
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).