highlight most recent entry in group on report

Question

I am trying to see if it is possible to highlight or conditionally format the most recent entry on a report&nbsp;_in each group_ - so if the report is grouped by Manager ID, and shows several updates per manager (see below), I want the latest entry to be a different color or highlightedID&nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; Update&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;notes1234_1234&nbsp; 7/10/19&nbsp; update here&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; notes and such1234&nbsp; 7/1/19&nbsp; &nbsp; another update here&nbsp; &nbsp;more notes1234&nbsp; 6/15/19&nbsp; another one&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blah blah_5678_5678&nbsp; 7/9/19&nbsp; &nbsp; update and what not&nbsp; &nbsp;some notes5678&nbsp; 7/5/19&nbsp; &nbsp; here is an update&nbsp; &nbsp; &nbsp; &nbsp; note note note5678&nbsp; 5/15/19&nbsp; again with an update&nbsp; &nbsp;notes and notes and notesSo the first lines for each ID would be highlighted (the one on 7/10/19 for 1234 and the one on 7/9/19 for 5678)Please help!!&nbsp; And thanks in advance :)

laurathacker · Answer

This answer assumes:1.&nbsp; Your ID (group value) is a related-reference field table parent record value2.&nbsp; That your report will always include the latest note/entryIn your Parent &lt; Child relationship, build a summary-field to bring back the&nbsp;Maximum [Record ID#] from the child table.&nbsp; Call this field [Max Notes Rec ID#]In your Parent &lt; Child relationship add the new [Max Notes Rec ID#] as a Lookup field back into the child-tableIn your child-table, build a formula-checkbox field [Latest Note].&nbsp; Formula: [Record ID#] = [Max Notes Rec ID#]In your report, you can then use Row colorization on the rows where the [Latest Note] checkbox is TRUE.

ryanstanford1 · Answer

To piggy back on QBPros_IDS response, this was exactly what I was thinking, but they beat me to it.

stephanielane · Answer

My key field is not the Record ID - it is the Manager ID....

laurathacker · Answer

The principle is the same.&nbsp; You still want the maximum Record ID# for the child record; and to look that up into the child table so you can evaluate if the [Record ID#] = [Max Record ID#] to determine it is still the latest-child record for the parent record.

stephanielane · Answer

Well I tried that, and it was checking the box on dates that are earlier than the latest update...&nbsp;

Forum Discussion

highlight most recent entry in group on report

9 Replies

Related Content

Report Column labels not saving

Highlight blank field within a report?

Formula - Most Recent Date

Most Recent Record

Highlight Date fields that are blank.

Recent Discussions

Can I use quickbase actions within the same table?

Question about relationships

Reports & Charts - Managing Client-Specific Name Visibility

Summary Table Question

Google Search is back