Mail to: Multiple records, multiple fields
Looking for a way to do a 1 click "email to" a list of contacts and their admins. I have the emails of both, with the ability to "email all" at the bottom of the table. I have a formula-url fiel...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSo you are sitting on a contact record and there is an embedded child table of admins?
If that is the case, you can create a text field which mirrors the email field on the child table but converts it to text,. Then use a combined text summary field in the relationship to get those email addresses up to the Parent contact.
Then convert that back to a text field using
SearchAndReplace([All Admin emails]," ; ",";")
That should remove the spaces around the semi colon and convert to text.
Then use that in your MailTo: formula.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If that is the case, you can create a text field which mirrors the email field on the child table but converts it to text,. Then use a combined text summary field in the relationship to get those email addresses up to the Parent contact.
Then convert that back to a text field using
SearchAndReplace([All Admin emails]," ; ",";")
That should remove the spaces around the semi colon and convert to text.
Then use that in your MailTo: formula.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Apologies for the lack of info.
Sittin on a Parent table (groups) with contacts embedded as the child (unfortunately can't share screenshots as info is private). The Child (contacts) have two email fields, one for the main contact, the other for contacts admin.
When I filter the Groups table I would like to have one button to email all contacts (to:) and admins (Cc:). This button can live on a "Home page". Currently, I have report linked buttons to automatically download the spreadsheet containing the email addresses. We then copy and paste in our native email client (Outlook).
Does that help?
------------------------------
Erik Pye
Affirmant Health Partners
-Learner -Includer -Developer -Positivity -Belief
------------------------------- MarkShnier__YouI think that this would be possible to do if the # of contacts was not more than 150. But I would have to work with you on a one on one basis to get this working. It would take a few hours of consulting time on a screen share session to get this working. Contact me via my signature link info if you have a bit of a budget to get this working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
