Skip to main content
Question

Size Query - Ranking and then Querying the Next Ranked Record

  • February 7, 2022
  • 0 replies
  • 233 views
LizChartrand
Forum|alt.badge.img+6
Hello!

I recently figured out how to rank records in QB by using the Size function to organize records chronologically.
I'd like to take that a step further and be able to rank records that fit a set of criteria and then query the very next record in the ranked sequence.

In other words, if I have 3 records Ranked 1, 2, 3 -
I'd like to be able to query information on Record 2 from Record 1 and, I'd like to be able to reference Record 3's information on Record 2.

If anyone has any suggestions, even if it's not specifically the size function, I'm all ears!

Thank you!

------------------------------
Liz Chartrand
------------------------------
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
Hi Liz,

I believe what you're looking for is the GetFieldValues() function paired with a query that includes your ranking. 

This video shows you how to use the GetFieldValues function along with another query ranking field. In your case, I would also include a formula in the query like [Rank]-1 to get the prior records rank.

Video will start at the point where this is demonstrated: https://youtu.be/HVaUfnuBp4s?t=780

------------------------------
Quick Base Junkie
------------------------------
Terms & ConditionsAccessibility statement