Forum Discussion

PaulAgnew's avatar
PaulAgnew
Qrew Trainee
5 years ago

Need Last Primary, Secondary and Tertiary Approver in Parent Table

I need to get the latest (max) approvers from a Status Log child table into the parent JE table to facilitate monthly reporting.  There are 3 approval/approver levels: 1) Primary, 2) Secondary and 3) ...
App builders
Relationships
PaulAgnew's avatar
PaulAgnew
Qrew Trainee
5 years ago
Any tips and recommendations?

------------------------------
Paul Agnew
IT Manager
Peak Properties
CA
9494070409
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Yes i do.  While this can probably be done, it will require a a log amount of code to parse out the pieces and then do the logic.  It's gunna be ugly.

A far more flexible solution would be to write out child records for the approvals.  Then it will be way easier get at the various approvers.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------