Discussions

 View Only
  • 1.  Preventing Notifications from going to yourself

    Posted 08-03-2022 09:08
    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
    ------------------------------


  • 2.  RE: Preventing Notifications from going to yourself

    Posted 08-03-2022 09:15
    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
    ------------------------------



  • 3.  RE: Preventing Notifications from going to yourself

    Posted 08-03-2022 09:22
    Edited by Anne Martin 08-03-2022 09:22
    Whoops, replied on wrong thread.

    ------------------------------
    Anne Martin
    ------------------------------



  • 4.  RE: Preventing Notifications from going to yourself

    Posted 08-26-2022 11:00
    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
    ------------------------------



  • 5.  RE: Preventing Notifications from going to yourself

    Posted 08-26-2022 11:58
    It will work just fine.

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



  • 6.  RE: Preventing Notifications from going to yourself

    Posted 08-26-2022 12:16
    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
    ------------------------------



  • 7.  RE: Preventing Notifications from going to yourself

    Posted 08-26-2022 12:53
    Looks good to me.

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



  • 8.  RE: Preventing Notifications from going to yourself

    Posted 08-26-2022 14:00
    Thanks!

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