Skip to main content
Question

Most Recent Record

  • Aug 27, 2025 3:17 PM UTC
  • 2 replies
  • 146 views

Forum|alt.badge.img

I have a parent table called Deliverables that pulls in the Project Name into my child table called Buy Out.

In Buy Out, each project has multiple Scopes.

Each Scope can have many line items over time, with a Date field that’s filled in by the user.

What I want:

A Table Report that groups by Project Name → then by Scope.

Under each Scope, I only want to display the most recent line item (based on the Date field).

So if Project A has Scopes Electrical, Mechanical, and Plumbing, I’d only see the latest record for Electrical, the latest for Mechanical, and the latest for Plumbing.

What’s happening now:

If I create a Summary field for Maximum Date, it only gives me the most recent record for the whole Project, not per Scope.

In a Summary Report, I can see the max dates by Scope, but I can’t get all the other line item details.

In a Table Report, I can group and sort so the latest is on top, but I can’t filter it to only show that one row per Scope.

What I’m asking:
How can I build a Table Report that actually only shows the most recent record for each Scope of each Project?

2 replies

Forum|alt.badge.img+11
  • Qrew Captain
  • Aug 27, 2025 4:09 PM UTC

If I understand your situation correctly, I think what you need to do is a create a formula field that gets the most recent of each scope, and then produce a summary with these formula fields.


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 24, 2026 10:50 PM UTC

You can do this with a formula checkbox on Buy Out that's only checked on the newest line for each Project and Scope, then filter the report on it.

 

Add a Formula - Checkbox field called [Latest for Scope]:

 

var text Q = "{10.EX.'" & [Related Deliverable] & "'}AND{12.EX.'" & [Scope] & "'}AND{8.AF.'" & ToText([Date]) & "'}";
Size(GetRecords($Q)) = 0

 

Swap 10 for the field ID of your Related Deliverable field, 12 for Scope and 8 for Date. It counts the lines for the same project and scope with a later date, and if there are none, that line is the latest.

 

Then on your table report add the filter Latest for Scope is checked and group by Project Name, then Scope. You get one row per scope with all the line item details.

 

If two lines in the same scope can share the latest date, both will show. Add a tie breaker on Record ID# if that matters.