Can I send emails to values from a multi select text field?
I want to be able to send emails to records entered or chosen from a multi select text field.
Forum Discussion
It sounds like Raj os asking how to send emails to whoever was selected in the multi select drop down.
They will first need to be parsed out into separate fields
so the formula for [email 1] would be
Part(ToText([my multi select field]),1,";")
The formula for [email 2] would be
Part(ToText([my multi select field]),2,";")
The in the Notification you just hand type those fields carefully listed vertically in the box
[email 1]
[email 2]
etc
[email 20]
They will first need to be parsed out into separate fields
so the formula for [email 1] would be
Part(ToText([my multi select field]),1,";")
The formula for [email 2] would be
Part(ToText([my multi select field]),2,";")
The in the Notification you just hand type those fields carefully listed vertically in the box
[email 1]
[email 2]
etc
[email 20]
- Hello, yes you got my question. Can you explain it in a more detailed way to implement this?
- I'm not sure what additional detail i can give you.
Make 20 email formula fields as i described above, and then type them into the ox for who gets notified. Try it for a couple of fields like [email 1] and [email ] and post back if you get stuck. - Hello, I tried separating the fields using the formula you suggested. My scenario is:
1. I have just name (text) as values in a multiselect text field.
2. If I stored their email addresses in different fields how would I make sure the name selected from the multi select corresponds to a specific email ? - Ok, so now its getting more complicated.
First of all, if these are actually users and not outside non-users, then just us a List User field because then you can multi select and also use it in an email Notification.
If these are outside non users, then one low tech solution is to make their dropdown choices in a format where you can directly parse out the email separate from the name. For example
Fred Flintstone - fred.flintstone@bedrock.com
Barney Rubble - barney.rubble@bedrock.com
If you need help with a formula to parse out the email addresses, I can help you with that once you standardize on a format. Like separating the name form the email address with a hyphen.- Is there a video tutorial to walk us through this? Having a more step-by-step tutorial would help as I'm still pretty new to QB.
------------------------------
Valerie Wong
------------------------------- MarkShnier__You
Qrew Legend
Valarie,
Can you post this as a new question explain your use case and reference this thread with a link. Maybe give an example of what in that Multi Select field. Userids? Email addresses? What field type is it?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- i tried the same but got error after saving the notification, can you pleas suggest.
in my case this was username. - Did you read the thread above? What field type is your [Email1] field? What is the error message?
- Please refer to the snap shot, i tried to show the in details as possible as i could.
- This posted image is very difficult to read on my ipad and I cannot read your formula. It looks like you have a field of type email. Perhaps you should try making a Notification of type Open. That allows sending emails to an email address. Or alternatively use a field of type User in a Notification of Type recipient.
- Part(ToText(Fox Employee],2,"- ")
this is the formula i am using, i created to different Email formula field but whenever i select the email from dropdown, both Email1 and Email2 is displaying the same value.
