Forum Discussion

ToddMolino's avatar
ToddMolino
Qrew Trainee
2 years ago

Creating a sequential numbering order based on Record ID

Hello, 

I have an Order Acknowledgments table (parent) and a Line Items table (child). 
Each Line Item is listed in an embedded report on each OA record. Currently, the RID of the Line Item is shown in the embedded report and I'd like to replace it with a sequential numbering system. So instead of the report displaying random record IDs of the items, I'd like the report to show "1" as the first item in the report, "2" as the second etc. These items are the related line items in the relationship to the OA. 


Any help would be greatly appreciated!


------------------------------
Todd Molino
------------------------------

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    np,
    This used to be really messy, but now its easy with a Formula Query.

    Try this

    var text QUERY = "{20.EX.'" & [Related Job] & "'} AND {3.LTE.'" & [Record ID#] & "'}";

    Size(
    GetFieldValues(
    GetRecords($QUERY),3))

    // replace the 20 with the fid for the field for related parent.
    // replace related job with the field name for [Related Parent]

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • ToddMolino's avatar
      ToddMolino
      Qrew Trainee
      2 years ago
      Thank you Mark!

      ------------------------------
      Todd Molino
      ------------------------------
    • BradElmore's avatar
      BradElmore
      Qrew Assistant Captain
      11 months ago

      Thank you Mark -- This worked for me as well.



      ------------------------------
      Brad Elmore
      ------------------------------
    • NoelHerron1's avatar
      NoelHerron1
      Qrew Member
      10 months ago

      Elegant solution, Mark. Thank you very much! Been looking for this for a while.



      ------------------------------
      Noel Herron
      ------------------------------