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 sho...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
------------------------------