Forum Discussion

MattMelrose's avatar
MattMelrose
Qrew Member
4 years ago

Using an email field to copy other field to subject line

Hello,

Is it possible to copy values from other fields to the subject line via either a formulated URL or formulated email field?

EG

Priority - HIGH
Address - 123 Fake St
Email field - 123fake@email.com

Button clicked to launch email client.
Populated emai:l via Email Field
Subject: Address - HIGH Priority

------------------------------
Matt Melrose
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Are you trying to launch off a Quickbase record and open up an email compose screen on the email client for your computer with the TO, CC BCC Subject and Body filled in?


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MattMelrose's avatar
      MattMelrose
      Qrew Member
      4 years ago
      Yup! that is exactly what I am trying to do.

      ------------------------------
      Matt Melrose
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        You can use a URL Formula to pre-populate many fields in your email message in addition to the recipient, such as the CC, BCC, Subject, and message body, like this:

        "mailto:"
        & [To:] // email field to email to an this could contain, a semi colon delimited string.
        & "?cc=" & [CC] // optional CC //note that the ? delimiter only gets used once, right after the TO.
        & "&bcc=" & [BCC]   //optional bcc
        & "&subject=" & URLEncode([Subject]) // optional Subject 
        & "&body=" & URLEncode([Body] // optional body

        note that you are constructing a URL, which needs to travel the vagaries of the internet and URLs do not allow any special characters or blanks.  So any fields which might contain illegal characters need to be URLEncoded.  The email recipients can be semi colon delisted.

        to get a carriage return you would use

        \n

        but that would need to be URLEncoded.

        like 

        & URLEncode ("\n\n")

        to start a new paragraph.

        As far as I know, this is the only syntax which will work on all email clients (so say gmail and Outlook and the rest).  It will NOT allow any fancy Rich Text ( like bold or font control), just plain text.

        Give it a try and post back if you get stuck.  The symptom of not URLEncoding will be that the page load into the email client  will stop at the first illegal character.





        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------