Multi-user Task Manager Summary Report by User

Question

I have a task manager in which I can assign multiple user to a single task via the [Assigned To] List-user field.&nbsp; So far I have not been able to make a summary report which breaks down the task assignment by individual users.For example,&nbsp; Bob, Mike and Jan can be assigned tasks.&nbsp; Bob and Mike are both assigned individual tasks, but Mike and Jan are both assigned to work another task together.Currently the summary looks like this:Assigned To&nbsp; &nbsp; &nbsp; # of TasksBob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Mike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1Jan, Mike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1I want it to look like this:​Assigned To&nbsp; &nbsp; &nbsp; # of TasksBob&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Mike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1The problem I keep running into is not being able to summarize records that contain multiple values in a single field.&nbsp; Anyone have any creative solutions?&nbsp; My Project Manager sure would like to see the total amount of tasking assigned to each user at a glance.------------------------------David Browne------------------------------

markshnier__you · Answer

The only way i can think to do this would be to use an Automation to maintain a child table of the individual Assignees. The Assignment record would need to have formula fields to parse out say the first 10 assignees fomr the LIst User field and then the Automation would fire when the Assignment record was added or edited. The Automation would delete all the children, then create the 10 Child records and then delete any blank ones with no Assignee.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

davidbrowne · Answer

I was thinking along those lines as well. I just don't know how to parse the names I get from UserlistToNames([Assigned To]) into separate fields.

I didn't quit follow the bit about the automation deleting the children. What are the children in this case?

Thanks for you help!

------------------------------
David Browne
------------------------------

markshnier__you · Answer

The formula to parse out the first user form a List User field would be

ToUser(Part(ToText(UserListToEmails([Assignees])),1,";"))

The 2nd user would be

ToUser(Part(ToText(UserListToEmails([Assignees])),2,";"))

In my suggested setup the Assignment record would have a child table so that if the ListUser Assignees were Curly, Larry and Moe, then there would be three children records, one for each. You would lookup ant info you needed from the Assignment record and then make your report off the child table of the individual assignees.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Forum Discussion

Multi-user Task Manager Summary Report by User

Related Content

Summary Reports

File Manager Plugin Passing Data to the Child Records

Maximum Summary field not working

Automating Manager Approval via Email

Managing record access for multiple data levels