Show only last value / entry

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have two tables in one to many relationship, and idea is following:
- One project can have many log entries.
I know how to create a table report, and sort, but what I need is a way to show only the date of last entry for the project? 

Can this be done, and how?

Thank you.
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
I think you could try a summary field and setting it to Maximum Record ID. That should be the most recent related record. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
If you want to know the maximum of the date field in a child table then make a summary field on the relationship  of the maximum of the date field in the child table.
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
if you just want to show the whole entry for the log child table but only show the  entry which is the last one, then  do that summary date field and look it up back down to the Log entries.

Then filter the embedded report where the date = summary maximum date.