Forum Discussion

ChethanaShetty1's avatar
ChethanaShetty1
Qrew Member
5 years ago

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
------------------------------
  • np,

     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
    ------------------------------