Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
3 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 projects table and aggregates them into a user to receive notification.  This way if, for example, someone uploads or adds comments to a contract everyone involved gets a notification.  The problem with this is the user that edits the record also gets the email notification.  They really do not need it since they made the change, it just creates another email.

Any idea on how to prevent the "current user" from getting an email notification?  It needs to be dynamic as we never know who will add the comments but they dont need to get their own comments in an email.

Thanks!

------------------------------
Ivan Weiss
------------------------------
Formulas and functions
NotificationsEmail
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Try this.  Expand to Twenty if you need more.


    ar text AssignedTo = ToText([Assigned To - INTERNAL]);

    var user AssignedOne = ToUser(Trim(Part($AssignedTo,1,";")));
    var user AssignedTwo = ToUser(Trim(Part($AssignedTo,2,";")));
    var user AssignedThree = ToUser(Trim(Part($AssignedTo,3,";")));
    var user AssignedFour = ToUser(Trim(Part($AssignedTo,4,";")));
    var user AssignedFive = ToUser(Trim(Part($AssignedTo,5,";")));

    ToUserList(
    If([Last Modified By] <> $AssignedOne, $AssignedOne),
    If([Last Modified By] <> $AssignedTwo, $AssignedTwo),
    If([Last Modified By] <> $AssignedThree, $AssignedThree),
    If([Last Modified By] <> $AssignedFour, $AssignedFour),
    If([Last Modified By] <> $AssignedFive, $AssignedFive))

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AnneMartin's avatar
      AnneMartin
      Qrew Trainee
      3 years ago
      Whoops, replied on wrong thread.

      ------------------------------
      Anne Martin
      ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      3 years ago
      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
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        It will work just fine.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------