Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Button to open email client and populate fields (including a report link)

I am trying to make a button that will open our email client (Outlook), and fill out the recipient from a QB field, and the subject, as well as populate the body with a report link. I found an old ...
NotificationsEmail
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Mike, you will need to make a combined text summary field of the child records email addresses.  The combined text summary only works on text type fields, so you will need to convert them to text fields.

The after rolling them up, you will need to use SearchAndReplace to make a string that the mailto will accept in the TO box.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago
Thanks all. Knowing it's text only situation, I was able to play around and make something work. I did find out that if you an apostrophe in your text, it messes with things. It will stop right at that apostrophe and not include any further text in the body of your email.

I did a searchandreplace and removed all apostrophes, but does anyone have a better solution?

------------------------------
Mike Tamoush
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Juiced has their 'Courier' add-on. It will integrate with your email service, allows embedded reports & attachments, etc. Outside of this or another add-on, there are not a lot of native options for emailing.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------