For the dropdown, create a new list with epdm group members listed.
As far as sending emails based on a data card variable, you'll find a lot of discussions on this board regarding that. There's not a simple answer.
There is 1- custom programming 2-Hard coded workflows to sort and send emails or 3-dynamic notifications. If you search in my old posts I show a method for using dispatch to read variables and populate a new email in outlook, but it's not 100% automated.
Thanks Corey, but I was hoping for the dropdown, I wouldn't have to "hard type" the static list. I was hoping the the list could come directly from the Group Membership list.
In 2010 I faced the same thing and wrote a vb.net add-in to handle it. Here is my original post. I was using a different company email then so that account is no longer active.
Here's what the add-in did:
- Used the IedmUserGroup5 interface and iterated through the group listing
- For each user, connected to the Active Directory server to query the email of the user
- Formed an email using data card variables
- Included an attachment for review in case they did not have access to EPDM
- Sent the email
Your case is different in that you need a form so you can select individual users. I tried that but found everyone in the group wanted to be notified so I opted for making the add-in email the entire group.
You can build a card list with an sql statement that queries the group and user tables, then yuo can select that card list in your form.
Here's the query we use (Note the group name).
INNER JOIN GroupMembers ON Groups.GroupID = GroupMembers.GroupID
INNER JOIN Users ON GroupMembers.UserID = Users.UserID
WHERE (Groups.Groupname = 'Product Development Engineering' AND Users.Enabled = 1 and GroupMembers.ProjectID=1)
ORDER BY FullName
As for the notification, we had to write a custom add-in to email people by pulling their name from a variable.