Deriving Website from Email Addresses

Ever look at a lead record and want to know more about it.  Your first instinct might be to visit the Lead’s website.  Don’t you hate it when the website field is blank but the email isn’t.  You have to copy the domain from the email address and then paste it into your browser.  That’s a minimum of 4 clicks and keystrokes.  What a waste of time!

Wouldn’t it be great, if you could automatically populate the website field based on email address? This solution is so simple that you’re going to hit yourself for not implementing it sooner.

1. Create a new Workflow Rule on Leads with the following filters:
Email contains @
Website equals [leaving the value blank]

2. Add a Workflow Field Update that updates the Website field with this formula:
“www.”& RIGHT(Email, LEN(Email)- FIND(“@”, Email ) )

3. Activate and enjoy!

You can also use this same formula to create a Custom Link for this purpose. You can also optionally filter out common domains like gmail if you want to.

Related posts:

1. Update Record Types from the Edit Page
2. Validating email addresses in Apex
3. New Opportunity Save Behavior is going live 1/4/2010
4. Creating a Formula Field to Sort Records in True Alphabetical Order
5. New Year’s Resolution 1: DeDuping Records

Permalink | Post a Comment | Subscribe to Post Discussion