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------------------------------
Original Message:
Sent: 09-28-2022 16:26
From: Todd Molino
Subject: 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.
------------------------------
Todd Molino
------------------------------