Skip to main content
Question

Prevent Notifications to yourself

  • Oct 26, 2019 4:11 PM UTC
  • 0 replies
  • 86 views

Forum|alt.badge.img+11
Good afternoon all!

I have a table for tasks.  Within the tasks table I have a field with a user list called Additional Task Followers.  This way we can select who gets notifications.  I also have a field for Assigned To which is the person the task is assigned to.

I have a formula field for Users To Receive Notifications and it combines these two lists.  So it takes Assigned To and Additional Task Followers and makes them one list.

I have a notification setup so that anytime a task is added, changes, etc. it notifies this Users To Receive Notifications list.  How do I exclude the person making the changes?  It is annoying to get notifications emails everytime we do something.  But the problem is I need to do it dynamically as multiple people could edit that task.

------------------------------
Ivan Weiss
------------------------------
This topic has been closed for replies.

  • Quickbase Staff
  • Nov 11, 2019 4:11 PM UTC
Ivan,

I just utilized a test app, and setup this formula to accomplish what you outlined here:
var text Users=UserListToEmails(ToUserList(ToUserList([Assigned To]),[Additional Task Followers]));
var text LastModifiedEmail=UserToEmail([Last Modified By]);

ToUserList(
If($LastModifiedEmail<>Trim(Part($Users,1,";")),ToUser(Part($Users,1,";"))),
If($LastModifiedEmail<>Trim(Part($Users,2,";")),ToUser(Part($Users,2,";"))),
If($LastModifiedEmail<>Trim(Part($Users,3,";")),ToUser(Part($Users,3,";"))),
If($LastModifiedEmail<>Trim(Part($Users,4,";")),ToUser(Part($Users,4,";")))
)

You could continue the pattern to contain all 20 possible choices for your List-User field. With this formula list user field in place, you would then trigger your notification to go to this list, and it will exclude whomever last edited the record.

------------------------------
Eric Mohlman
------------------------------