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 to send messages that are located within the medical record (well really the case messaging table I suppose).

When a user sends a message out, all of the users assigned to that medical record receive an email to check the message.  The problem is that the person sending the message also gets the email.  

There is no need for the person sending the message to receive the email.  I would like to set up the message so that it emails all EXCEPT the user sending the message.  There is no except function in the notifications. 

Any help on this would be appreciated.

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