Forum Discussion

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

Qrew Trainee

5 years ago

Any tips and recommendations?

------------------------------
Paul Agnew
IT Manager
Peak Properties
CA
9494070409
------------------------------

MarkShnier__You
Qrew 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
------------------------------
- PaulAgnew
  Qrew Trainee
  5 years ago
  Thank-you Mark. The approval child records are stored in the Status Log (child table). This is more-or-less working now via an automation that calculates the "latest" Primary, Secondary and Tertiary approver. I'll pose additional questions as I run into any problems.
  
  Again, thanks so much.
  
  Regards,
  Paul
  
  ------------------------------
  Paul Agnew
  IT Manager
  Peak Properties
  CA
  9494070409
  ------------------------------