Combine Formula List-User with List-User field

Question

Can we combine a Formula - List-User field with a List-User field? I'd like to use the field as the 'Notify Whom' value in notifications and avoid creating a set of notifications for each field.

Thanks!

------------------------------
Heather Bryant
------------------------------

markshnier__you · Answer

Try thisToUserList([userlist 1],[userlist 2])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

heatherbryant2 · Answer

Thanks, Mark! That worked. I had tried ToUserList([user1], [user2], [user3], [userlist]) and got an error that userlist was expected to be a user. When I combined [user1], [user2], [user3] into a user list, the formula you provided worked.

------------------------------
Heather Bryant
------------------------------

markshnier__you · Answer

Right,the ToUserList function will combine either a set of User field types or a set of User List field types but you can't mix them in the same function..------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

mattstephens · Answer

You can however just have a touserlist function inside a touserlist function to combine single users and user lists:ToUserList(&nbsp; &nbsp; ToUserList( [Project controller username], [Project - APM Username], [Record Owner]), //individual users&nbsp; &nbsp; [Asset Engineering Delegates] //lists of users)

Forum Discussion

Combine Formula List-User with List-User field