Forum Discussion

Qrew Cadet

3 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

Qrew Legend

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
------------------------------

NoelHerron1

Qrew Member

2 years ago

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

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