function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jon2010Jon2010 

Create mailto: field with subject line

Hi,

 

I'd like to create a mailto: field for Cases so that each case can have a field that would look something like this:

 

"mailto:" + {Contact.Email} + "?subject=Case " + CaseNumber + " " + Subject

 

I tried it, but it didn't work. Firstly, the whole field was formatted as text, and secondly, Contact.Email was giving me a "mailto:contact.email@domain.com" rather than a simply "contact.email@domain.com".

 

Is there any way to do this...?

 

Thanks in advance.

 

Jon

EnthEnth
Try creating a new custom field, of type URL, and create a workflow that sets the value of this field to your formula.
Jon2010Jon2010

Thanks for the advice. I probably should have added that I'm pretty new at this.

 

I've now created a custom field of type URL, but where do I go to create a new workflow?

 

Thanks,

Jon

marco_29marco_29

You do not need any workflow:

 

Create a formula, data type is field:

formula is:

HYPERLINK( "mailto:" & Contact.Email , "email me")

 

 

 

Jon2010Jon2010

Thanks Marco, that worked a treat.

 

For any future complete newbies trying to follow this, what I did in the end was:

  • Create a new custom field with Data Type set to "Formula"
  • Set the Formula Return Type to "Text"
  • As the formula itself, I entered:

HYPERLINK("mailto:" +  Contact.Email  + "?subject=Case " + CaseNumber + " - " + Subject, "Click here to create email with subject")

Thanks for your help.