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

3 years ago

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
------------------------------
BradElmore
Qrew Assistant Captain
2 years ago
Thank you Mark -- This worked for me as well.

------------------------------
Brad Elmore
------------------------------
NoelHerron1
Qrew Member
2 years ago
Elegant solution, Mark. Thank you very much! Been looking for this for a while.

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