Skip to main content

Returning the last item from a rollup field

  • July 9, 2021
  • 2 replies
  • 28 views

Forum|alt.badge.img+4
  • Participating Frequently

Hi

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

Help!

2 replies

Justin_Barrett
Forum|alt.badge.img+21

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


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • July 10, 2021

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.