Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Returning the last item from a rollup field

Topic Labels: Formulas
575 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi

I need to extract the last record from a rollup field where multiple records exist.

Help!

2 Replies 2

What type of data is being rolled up? Dates? Numbers? Strings? Knowing this will help us know how to find that last value.

It would also be helpful to know if you want a value from the last record in the list of linked records, or the last record based on a field value in the linked table. They are not always the same.

The more information you can provide, the better. There are various ways of obtaining data from the “last” record. In some situations, the information can be obtained in a single rollup field. In other situations, you need a system of rollup fields where you pass information back and forth between the two tables. Still other situations call for a script.