Skip to main content
Question

Preventing Notifications from going to yourself

  • August 3, 2022
  • 0 replies
  • 99 views
Forum|alt.badge.img+11
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • August 3, 2022
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement