Forum Discussion

ChrisSipes's avatar
ChrisSipes
Qrew Cadet
4 years ago

Opt out of email notification to all users in a role

I have my users grouped in roles.  I have email subscriptions that send to all users in a role.

I have one user who would like to opt-out of one of the emails, but I need him still to be in that role for access purposes.  How do I set the "Deliver to" field on my subscription to exclude him?


------------------------------
Chris Sipes
------------------------------
Formulas and functions
NotificationsEmail

5 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago

    np,
    Create a field called [Current User] with a formula of 

    User()

    Make a copy of the report with he name suffixed with (subscription version)

    add a filter to the report

     [Current user] is not equal to (type in the email address on the user to block.)

    Change your subscription to use the "Subscription version" of the report.

    Y'er done.




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ChrisSipes's avatar
      ChrisSipes
      Qrew Cadet
      4 years ago

      The email seems to still send to him, but with an empty table.  (For the other users, I need them to get the emails, even when empty, which is why that selection box is checked.)

      Did I do something incorrectly?



      ------------------------------
      Chris Sipes
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        4 years ago

        It is unusual to send an email to users with an empty report. My solution will only work if the checkbox is unchecked.



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