Forum Discussion

Qrew Assistant Captain

5 years ago

Combine Formula List-User with List-User field

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. Th...

Formulas and functions

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

Try this

ToUserList([userlist 1],[userlist 2])

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

HeatherBryant2
Qrew Assistant Captain
5 years ago
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
  Qrew Legend
  5 years ago
  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 Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - MattStephens
    Qrew Cadet
    3 months ago
    You can however just have a touserlist function inside a touserlist function to combine single users and user lists:
    ToUserList(
    ToUserList( [Project controller username], [Project - APM Username], [Record Owner]), //individual users
    [Asset Engineering Delegates] //lists of users
    )