Discussions

 View Only
  • 1.  Creating a sequential numbering order based on Record ID

    Posted 09-28-2022 16:26
    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
    ------------------------------


  • 2.  RE: Creating a sequential numbering order based on Record ID

    Posted 09-29-2022 11:04
    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
    ------------------------------



  • 3.  RE: Creating a sequential numbering order based on Record ID

    Posted 09-29-2022 14:22
    Thank you Mark!

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



  • 4.  RE: Creating a sequential numbering order based on Record ID

    Posted 05-24-2023 14:20

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



    ------------------------------
    Brad Elmore
    ------------------------------



  • 5.  RE: Creating a sequential numbering order based on Record ID

    Posted 06-23-2023 17:37

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



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