Skip to main content
Question

Creating a sequential numbering order based on Record ID

  • September 28, 2022
  • 0 replies
  • 311 views
Forum|alt.badge.img+5
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement