Forum Discussion

SamRozenfeld's avatar
SamRozenfeld
Qrew Trainee
2 years ago

Auto numbering report rows

Hello, Can a simple incremental row number be added to the report? Regardless of how the report is sorted, I want to see a record number starting from the top of the current sort order. Any help is...
BrianSeymour's avatar
BrianSeymour
Qrew Assistant Captain
2 years ago

I recall seeing Quickbase Junkie writeup with a video walkthrough, but as Chayce mentioned, that would only work by matching the Formula Query logic with the report logic. If the records are resorted, the Formula Queries won't recalculate.

Here's the Quickbase Junkie link to Rank Records Using the 'Size' Query Function.

Unfortunately, I think the simple answer to your question is "no" with native Quickbase. You'd have to leverage custom Code Pages or pull QB data into another platform.



------------------------------
Brian Seymour
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    I just realized I sort of have a solution. 
    make a formula field or even a report formula field and with a formula of 1.  Call it [Row Number]. Make  a summary report contrived to have one row per record. As a last resort include the Record ID as a group by. 


    Then include [Row Number] on the report and set the summary method to Running Totals  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------