Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
5 years ago

Sending a Notification to a Dynamic List of Users

I have a master table "Projects" and a child table "Discussion Board" which includes fields for a title, description, status (open/closed), and due date.  I am going to create another child table for ...
NotificationsEmail
Quickbase Automations
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
The users on the Project team should be combined into a listuser field type by formula.

I believe the syntax is

ToUserList(
[Project team member 1 userid],
[Project team member 2 userid],
[Project team member 3 userid],
[Project team member 4 userid])

Then just look that up down to the child table and use it in an email notification.
SanjayGupta's avatar
SanjayGupta
Qrew Member
4 years ago
Hi, I am having a requirement where i need to send notifications to list of users based on country.
Can we assign a field in "Notify whom" section so that every time field is populated with dynamic users list.
i am not able to insert field in "Notify whom" like in Email subject, Body. Can you pls suggest how to proceed further.
Thanks

------------------------------
Sanjay Gupta
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    Should be easy.

    If the recipients are users, create a regular Notification called "Recipient" type, else if not user, then create of type "Open"

    Carefully type the individual fields which hold single email address into the box of recipients.

    the format is like

    [email 1]
    [email 2]


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