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
------------------------------
Question
Latest Record
This topic has been closed for replies.
+24np,
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.