Constructing URLs in CRM Workflow

Posted on July 13th, 2010.

Consider the example below: On a contact record, I have an attribute called Full URL that is a complete URL and two other partial URLs (a root and suffix) that combined would create the same full URL.

image

If I use these fields in a workflow e-mail like this:

image

The resultant e-mail in the inbox looks like this – you can see that they are both clickable links…

image

But if you try to build a hyperlink in the e-mail using a mixture of some typed text and an attribute value like so:

image

It doesn’t come across as a complete URL in the sent e-mail.

image

So, what you can do is perform your URL construction in a workflow step, and then store the constructed URL in a CRM field before you try to use the URL in the e-mail.

Here’s how:

On the Contact record, I create a new text field called “Constructed URL”. I will use workflow to update this value with my combination of text and field values. So now the workflow looks like this – 2 steps:

  1. update the ‘Constructed URL’
  2. send the e-mail that contains it

image

This is how you update the Constructed URL attribute in the workflow:

image

and this is the e-mail template:

image

When I run the workflow, it fills in the Constructed URL field and this is a clickable line:

image

And the email looks like this:

image

Make a Comment

Make A Comment: ( None so far )

blockquote and a tags work here.

Spam Protection by WP-SpamFree

About

Adventures in Microsoft CRM

RSS

Subscribe Via RSS

  • Subscribe with Bloglines
  • Add your feed to Newsburst from CNET News.com
  • Subscribe in Google Reader
  • Add to My Yahoo!
  • Subscribe in NewsGator Online
  • The latest comments to all posts in RSS
  • Subscribe in Rojo

Meta

Liked it here?
Why not try sites on the blogroll...