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------------------------------
Original Message:
Sent: 08-03-2022 09:08
From: Ivan Weiss
Subject: 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
------------------------------