Forum Discussion

HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
4 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.

Thanks!

------------------------------
Heather Bryant
------------------------------
Formulas and functions

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 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's avatar
      HeatherBryant2
      Qrew Assistant Captain
      4 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's avatar
        MarkShnier__You
        Qrew Champion
        4 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
        ------------------------------