Discussions

Expand all | Collapse all

Using an email field to copy other field to subject line

  • 1.  Using an email field to copy other field to subject line

    Posted 21 days ago
    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
    ------------------------------


  • 2.  RE: Using an email field to copy other field to subject line

    Posted 21 days 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
    ------------------------------



  • 3.  RE: Using an email field to copy other field to subject line

    Posted 21 days ago
    Yup! that is exactly what I am trying to do.

    ------------------------------
    Matt Melrose
    ------------------------------



  • 4.  RE: Using an email field to copy other field to subject line

    Posted 21 days 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
    ------------------------------



  • 5.  RE: Using an email field to copy other field to subject line

    Posted 21 days ago

    Wonderful, appreciate you help, works flawlessly