Forum Discussion

DavidBrowne's avatar
DavidBrowne
Qrew Trainee
6 years ago

Multi-user Task Manager Summary Report by User

I have a task manager in which I can assign multiple user to a single task via the [Assigned To] List-user field.  So far I have not been able to make a summary report which breaks down the task assig...
DavidBrowne's avatar
DavidBrowne
Qrew Trainee
6 years ago
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
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
------------------------------