Tip #253: Keep your emails unique

Matching Senders Account

Say, you want to do some checks for inbound emails on Senders Account. It will work well until one of other email-enabled entities (typically systemuser) has a record with the same email address. Having multiple system entities (systemuser, contact, account) with the same email is a bad idea because, when system starts matching sender’s email […]

Tip #250: Where do you see Advanced Find View

One of the system views for every entity in any CRM organization is so called Advanced Find View. It’s rarely customized, probably because there is no clear understanding when and how this view is used. System entities might have some columns added to this view while all custom entities receive Name and Created On ubiquitous […]

Tip #240: Once bitten, twice filtered

Anything that’s been done twice is usually better. That includes double cream and double barreled. Except that report pre-filtering does not work if you need a filtering entity to be included more than once in your SQL. Consider this totally random piece of SQL: You cannot just apply pre-filtering because alias CRMAF_FilteredAccount cannot be used […]

Tip #238: My workflow is my business

Workflow scope

Hey, everybody, Larry’s opportunity pipeline this month is again bigger than everyone else’s. Larry, what’s your secret? Larry, being somewhat softened by reasonable quantities of flavored C2H5OH, was more than happy to share his fortunes: It’s all about power of automatic workflows, my friends. See how I automatically increase opportunity value the moment it’s created? […]

Tip #236: How to be a time[r] lord

Timer Control

Spring ’14/SP1 release has introduced a number of very exciting features to the customer service functionality of Dynamics CRM including Service Level Agrements and Entitlements. The decision also has been made to introduce Spießrutenlaufen, previously reserved for developers, to the customer service officers. Yes, I’m talking about timer control The other good news is that […]

Tip #230: Ban the browse button

Adding assembly references

I like German words. Take, for example, Spießrutenlaufen. If you like me, and don’t speak a word of German, you know, just by looking, that the word means business, the word means corporal punishment. I often wonder if ignorance of the developers can be cured by introduction of Spießrutenlaufen for coders. Function is longer than […]