Show only last value / entry

Question

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.

chuckgrigsby · Answer

I think you could try a summary field and setting it to Maximum Record ID. That should be the most recent related record.&nbsp;

quickbasecoachd · Answer

If you want to know the maximum of the date field in a child table then make a summary field on the relationship &nbsp;of the maximum of the date field in the child table.

quickbasecoachd · Answer

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.

Forum Discussion

Show only last value / entry

Related Content

Find and Replace Field Values

Show related records

Using AND with Null values

Jinja If statement equals field value

Extract Date and Comment from prepend log entry field