Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
2 years ago

Preventing Notifications from going to yourself

Hi everyone, On several of my tables I have a User To Receive Notifications which is a formula list user field. It takes the various users involved in a project from various user fields on my proje...
Formulas and functions
NotificationsEmail
IvanWeiss's avatar
IvanWeiss
Qrew Captain
Mark, what happens if I make lets say 20 of these and there are only 3 users assigned?  Will it still work or generate an error?

------------------------------
Ivan Weiss
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago
It will work just fine.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    2 years ago
    This would work fine too, right?

    ToUserList(
    If([Last Modified By] <> [Submitter], [Submitter]),
    If([Last Modified By] <> [Project Coordinator], [Project Coordinator]),
    If([Last Modified By] <> [Project Solutions], [Project Solutions]),
    If([Last Modified By] <> [Legal Reviewer], [Legal Reviewer]),
    If([Last Modified By] <> [Insurance Reviewer],[Insurance Reviewer]),
    If([Last Modified By] <> [Project Manager],[Project Manager])
    )

    I am dynamically creating the userlist in the formula field as is.  The end user is not selecting it.  So I dont think I need the trim part...

    ------------------------------
    Ivan Weiss
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew Champion
      2 years ago
      Looks good to me.

      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • IvanWeiss's avatar
        IvanWeiss
        Qrew Captain
        2 years ago
        Thanks!

        ------------------------------
        Ivan Weiss
        ------------------------------