Roll Up Field Reference Record

[Erica_Ferguson]

Hi there. I’m pretty new to airtable and am having an issue with something that feels like it should be quite simple so I am assuming I am missing something obvious.

I have a Product table linked to a Product Bundle table. In a single record in the Product Bundle table I have multiple linked records from inventory from name, cost roll-up, quantities etc… Works great. One thing that would be super handy is to find the individual item that is linked from the Product table with the closest expiry date. At the moment I am able to use a roll-up max value field to find the earliest expiry date but I cannot figure out how to reference the record name that it belongs to.

For reference, I have 10-20 products linked in one bundle and the expiration determines how I will sell the particular product or if I can at all. So, by finding the record with the earliest expiry date, I can replace that item or order new stock. I hope this makes sense.

Thanks in advance,
Erica

[Kamille_Parks]

How to pull a decimal number out of an Array OR how to use conditional lookup in combination with MA... Formulas

If: You have records in Table 1 linked to one or more records in Table 2, You have {Field A} in Table 2 that can be compared with MAX(values) or MIN(values) (i.e. “what is the most recent date?”, “what is the smallest number?”) You want Table 1 to pull in not just what is the max (or min) of every linked record’s {Field A}, but the value of {Field B} associated with whatever record has the max (or min) value for {Field A} Then follow along in this episode of BuiltOnAir (Season 8, Episode 2, …