Forum Discussion

JosephMahon's avatar
JosephMahon
Qrew Cadet
5 years ago

Email Notification (Send To All Except Current User)

My app is set up to function like a medical record. Here is the set up: Medical Record: Parent Case Messaging:  Child When a user is granted access to the medical record they are also able t...
NotificationsEmail
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
I assume that you have a list user field on the Medical Record where Multiple Users are assigned.  Then you must be looking up that field down to the Messages Child table

Try this as a formula List User field.  It will work for up to 5 Assign to users.


var 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 (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------