Is there a way to find second last record ID # ?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Can we find 2nd largest/maximum record id # ?

I can find maximum record ID #  but in one of my scenario i need to find second maximum record id #.

Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
The 2nd largest Record ID is the largest record ID subject to the condition that it is less than the largest Record ID.  I assume that you have a relationship.  If you have used a Summary field to get the largest record ID#, then do a lookup of that value down to the child table.  

Then make a second summary field (duplicate the first one if you like) but add in the filter that the Record ID is less than the highest Record ID.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Thanks Mark,

It works for me.