Forum Discussion

Qrew Captain

5 years ago

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

NotificationsEmail

Qrew Captain

So would that work between the save and the notification going out? I would think that formula would only update once you hit save and I am not sure what comes first, chicken or the egg?

------------------------------
Ivan Weiss
------------------------------

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

The record will be fully saved and all fields recalculated, including summary fields, and then the Notification will fire if the conditions are met.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

IvanWeiss
Qrew Captain
5 years ago
Thanks so much everyone! Just tried implementing this. I had to tweak that a bit as I actually have (3) fields that I need to combine into my userlist. I placed this in my "Users to Receive Notifications" field. The full code I used is as follows and hopefully I got it right!

var text Users=UserListToEmails(ToUserList(ToUserList([Assigned To]),ToUserList([Additional Task Followers]),ToUserList([Task Owner])));
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,";"))),
If($LastModifiedEmail<>Trim(Part($Users,5,";")),ToUser(Part($Users,5,";"))),
If($LastModifiedEmail<>Trim(Part($Users,6,";")),ToUser(Part($Users,6,";"))),
If($LastModifiedEmail<>Trim(Part($Users,7,";")),ToUser(Part($Users,7,";"))),
If($LastModifiedEmail<>Trim(Part($Users,8,";")),ToUser(Part($Users,8,";"))),
If($LastModifiedEmail<>Trim(Part($Users,9,";")),ToUser(Part($Users,9,";"))),
If($LastModifiedEmail<>Trim(Part($Users,10,";")),ToUser(Part($Users,10,";"))),
If($LastModifiedEmail<>Trim(Part($Users,11,";")),ToUser(Part($Users,11,";"))),
If($LastModifiedEmail<>Trim(Part($Users,12,";")),ToUser(Part($Users,12,";"))),
If($LastModifiedEmail<>Trim(Part($Users,13,";")),ToUser(Part($Users,13,";"))),
If($LastModifiedEmail<>Trim(Part($Users,14,";")),ToUser(Part($Users,14,";"))),
If($LastModifiedEmail<>Trim(Part($Users,15,";")),ToUser(Part($Users,15,";"))),
If($LastModifiedEmail<>Trim(Part($Users,16,";")),ToUser(Part($Users,16,";"))),
If($LastModifiedEmail<>Trim(Part($Users,17,";")),ToUser(Part($Users,17,";"))),
If($LastModifiedEmail<>Trim(Part($Users,18,";")),ToUser(Part($Users,18,";"))),
If($LastModifiedEmail<>Trim(Part($Users,19,";")),ToUser(Part($Users,19,";"))),
If($LastModifiedEmail<>Trim(Part($Users,20,";")),ToUser(Part($Users,20,";")))
)

------------------------------
Ivan Weiss
------------------------------