Re: Email Notification (Send To All Except Current User)

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
------------------------------