Forum Discussion

SamRozenfeld's avatar
SamRozenfeld
Qrew Trainee
9 months 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 greatly appreciated.



------------------------------
Sincerely,
Sam Rozenfeld
------------------------------

7 Replies

  • Does [Record ID#] suit your need?



    ------------------------------
    Adam Krzyzanek
    ------------------------------
    • SamRozenfeld's avatar
      SamRozenfeld
      Qrew Trainee

      No, because Record IDs are permanent. I am trying to add a sort order number. 



      ------------------------------
      Sam Rozenfeld
      ------------------------------
      • AllanS's avatar
        AllanS
        Qrew Member

        This would give you a row number.

        var text Query = "{3.LTE.'" & [Record ID#] & "'}";
        Size(GetRecords($Query))



        ------------------------------
        Allan S
        ------------------------------

  • 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

      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
      ------------------------------