Combine User and User list

Question

I don't know why I can't get this one. I have multiple user fields, and a userlist field. I simply want to make one formula userlist field from all.

I know with just users it's

ToUserList([user1],[user2]....)

How to I add the userlist into this?

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

You can combine apples, and you can combine oranges, but not apples and oranges together.
Similarly, you can combine users and userlists, but not users and userlists.

So we need to make the users into small userlists.

ToUserList(ToUserlist([user1]), ToUserlist[user2]...., [My Userlist field])

Now all of the comma separated elements are all apples.

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

michaeltamoush · Answer

Thanks! I found out this also worksToUserList(ToUserlist([user1],[user2],[user3]...), [My Userlist field])------------------------------Mike Tamoush------------------------------

markshnier__you · Answer

yes, cleaner for sure!------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Combine User and User list

Related Content

Get the role of a user in a user field

Notification to EOTI user

Sorting Combined Text Field by Record ID#

Field to "assign" a user group

Show unique parent records for current user