Latest Record
I have 2 table Employee and Task. I want to create report with employee name along with Latest task assigned to him. Anyone please help me on this ------------------------------ Chethana Shetty ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
Make a summary field on the relationship of the maximum Record ID of the tasks. Look that value up back down to the tasks and called it Record ID of most recent task.
Make another summary field, but this time make it a combined text summary field of the task name but add the filter that the Record ID equals the Record ID of the most recent task.
If you don't like the "pill" appearance of the most recent task you can then make a new formula field on the employee table
ToText([Most recent Task name])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make a summary field on the relationship of the maximum Record ID of the tasks. Look that value up back down to the tasks and called it Record ID of most recent task.
Make another summary field, but this time make it a combined text summary field of the task name but add the filter that the Record ID equals the Record ID of the most recent task.
If you don't like the "pill" appearance of the most recent task you can then make a new formula field on the employee table
ToText([Most recent Task name])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------