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

ToddMolino

Qrew Cadet

3 years ago

Thank you Mark!

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