Forum Discussion

Qrew Captain

3 years ago

Preventing Notifications from going to yourself

Hi everyone, On several of my tables I have a User To Receive Notifications which is a formula list user field. It takes the various users involved in a project from various user fields on my proje...

Formulas and functions

NotificationsEmail

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

3 years ago

Try this. Expand to Twenty if you need more.

ar 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 (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

AnneMartin
Qrew Trainee
3 years ago
Whoops, replied on wrong thread.

------------------------------
Anne Martin
------------------------------
IvanWeiss
Qrew Captain
3 years ago
Mark, what happens if I make lets say 20 of these and there are only 3 users assigned? Will it still work or generate an error?

------------------------------
Ivan Weiss
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  It will work just fine.
  
  ------------------------------
  Mark Shnier (Your Quickbase Coach)
  mark.shnier@gmail.com
  ------------------------------
  - IvanWeiss
    Qrew Captain
    3 years ago
    This would work fine too, right?
    
    ToUserList(
    If([Last Modified By] <> [Submitter], [Submitter]),
    If([Last Modified By] <> [Project Coordinator], [Project Coordinator]),
    If([Last Modified By] <> [Project Solutions], [Project Solutions]),
    If([Last Modified By] <> [Legal Reviewer], [Legal Reviewer]),
    If([Last Modified By] <> [Insurance Reviewer],[Insurance Reviewer]),
    If([Last Modified By] <> [Project Manager],[Project Manager])
    )
    
    I am dynamically creating the userlist in the formula field as is. The end user is not selecting it. So I dont think I need the trim part...
    
    ------------------------------
    Ivan Weiss
    ------------------------------