Prevent Notifications to yourself
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 ...
Forum Discussion
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
------------------------------
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
------------------------------