Hyperlink to Email - Gmail

Periscope has a lot of cool functionality around converting links to a simpler format using Markdown language. However, doing things that require more advanced functionality such as bringing up an email takes a little more maneuvering. Luckily, the internet can be a kind place with logic from time to time. From this post:


We can use this format:

  '[' || table.email ||'](https://mail.google.com/mail/?view=cm&fs=1&to=' || replace(table.email,'+'
,'%2B') || '&su=&body=)'

If you're using something other than gmail and find out how to get this working, please post below!

Note: for plus signs, use %2B to replace any + in your email address!

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Here's one I did for creating links to salesforce. 


      '[' || o.name || '](https://<instance>.salesforce.com/' || o.id || ')'
    from sfdc.sf_opportunity o
    Reply Like 1
Like7 Follow
  • 1 yr agoLast active
  • 1Replies
  • 501Views
  • 3 Following