Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
5 years ago

How do I auto-populate a User List field with users defined in other fields

We have a form in our CRM which allows us to post client activity log entries. In the form we can add multiple users to a user select field so that they can receive notifications. I need to pre-po...
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
So you are saying that the parent record has a some user fields  and the child has a List User data entry field.  Why not just make a formula to combine them all, by formula into one field to be used for Notifications.  Post back if you need help with the formula.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
JosetteTrux's avatar
JosetteTrux
Qrew Member
5 years ago
Mark - Could you provide instructions on how to create such formula for Notifications?

Thanks,
Josette Trux

------------------------------
Josette Trux
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    if you want to combine several user fields into one UserList field, then the formula would be

    ToUserList([User Field 1], [User Field 2], [User Field 3], etc   )

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