highlight most recent entry in group on report

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
I am trying to see if it is possible to highlight or conditionally format the most recent entry on a report 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 highlighted


ID       Date      Update                       notes
1234
1234  7/10/19  update here                notes and such
1234  7/1/19    another update here   more notes
1234  6/15/19  another one                blah blah
5678
5678  7/9/19    update and what not   some notes
5678  7/5/19    here is an update        note note note
5678  5/15/19  again with an update   notes and notes and notes


So 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!!  And thanks in advance :)
Photo of Stephanie Lane

Stephanie Lane

  • 210 Points 100 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
This answer assumes:

1.  Your ID (group value) is a related-reference field table parent record value
2.  That your report will always include the latest note/entry

In your Parent < Child relationship, build a summary-field to bring back the Maximum [Record ID#] from the child table.  Call this field [Max Notes Rec ID#]

In your Parent < Child relationship add the new [Max Notes Rec ID#] as a Lookup field back into the child-table

In your child-table, build a formula-checkbox field [Latest Note].  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.
Photo of Ryan Stanford

Ryan Stanford

  • 1,992 Points 1k badge 2x thumb
To piggy back on QBPros_IDS response, this was exactly what I was thinking, but they beat me to it.
Photo of Stephanie Lane

Stephanie Lane

  • 210 Points 100 badge 2x thumb
My key field is not the Record ID - it is the Manager ID....
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
The principle is the same.  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.
Photo of Stephanie Lane

Stephanie Lane

  • 210 Points 100 badge 2x thumb
Well I tried that, and it was checking the box on dates that are earlier than the latest update... 
Photo of Stephanie Lane

Stephanie Lane

  • 210 Points 100 badge 2x thumb
It really needs to be based on that date field.....
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
Can you call me please at 626 771 0454
Photo of Stephanie Lane

Stephanie Lane

  • 210 Points 100 badge 2x thumb
Thank you so much, IDS (I didn't catch your name) - You are awesome!
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
You're welcome.  
Laura Thacker