Forum Discussion
- MarkShnierQrew CadetNo, there is not away to send the email as a cc. The best that you can do is to indicate in the body text who the TO is and who the CC is. But the actual email will be a TO in both cases.
- PaulaPaulaQrew MemberMark:
Is there a way to set up multiple users to receive an e-mail notification? The first person I want the notification sent to is the person assigned to that record. To do this, i have selected "The user listed in the field: xxx" in the Notify Whom section. I then want that same notification sent to this individual's manager. Is there a way to do this within the same notification when I want one recipient to be pulled from a QuickBase data field or would I nbeed to set up two notifications - one for the user & another for the manager? The manager will not change, but the individuial assigned to the record will change.
Thanks!
Paula - MarkShnierQrew CadetThe best way to do this is to create a formula List-User type field called [employee and their manager]. Then that field will appear on the drop down choice for the recipient. Duplicating notifications is a losing battle to keep them in synch - double work, so you are right to suspect that there is a better way.
here is the help on a List-user formula
https://www.quickbase.com/db/6ewwzuuj?a=dr&r=fx&rl=tg - ArchiveUserQrew CaptainIs there a way to do this when the email needs to go to
1) A Quickbase User
2) A non-QB user (i.e., it's pulling the email address from the "requestor" field on a form)
I have been trying to get this to work with the ToUserList function, but have not been successful. Any ideas are appreciated. - RyanStanford1Qrew CaptainI've been able to do something similar by having the Notification set to Open, which lets me put in email addresses, QB user or not. You could then use a formula field to add these email addresses into a list, and that field can be added to the notification.
Below is the code to get the email of a QuickBase User:
If(ToText([QB User]) <>"", UserToEmail([QB User]),"")- QuickBaseCoachDQrew Captainre: use a formula field to add these email addresses into a list
_In my experience, there is not a way to concatenate emails addresses together in a formula field in any format such as comma or semi colon delimited and get them to work in the email who box. They have to be listed as individual fields.