What's Online

If you were unable to attend the SalesForce.com ecosystem conference earlier this month, or if you attended but had simultaneous sessions you had wanted to attend so that you had to miss some, you can find videos for most of the sessions at the following link: DreamForce '09 videos.

Some highlights:
Formula Magic - create groups of roll-up summary fields then graphically represent their contents right on the record's detail page, or in list views.
New SFDC for Outlook - get a peak at the new Outlook integration utility coming soon.
Non-profit Starter Pack intro - Tips on getting the most out of the NPSP for non-profit organizations.
Donor and Member Managment - More tips for non-profit organizations
AppExchange Recommended Sales Apps - introduction to some great apps for sales managers to implement, such as: a business card scanning app; X Squared mass contact updated utility that updates all contact addresses when the Account's address changes (the company moves); Account News Feed; Landslide custom sales process manager; Engage B2B by Silverpop email behavior tracking for lead scoring and sales rep notification automation; and Sales Genius for email-to-website click tracking visible within SFDC.
Sales Process Productivity - For companies newly implementing a universal CRM system, with emphasis on 1) effective end user adoption and change management within a context of ongoing process improvement within phased roll-out; and 2) sales performance dashboards
Platform State of the Union - use a Visio-like graphical user interface to create approvals now and standard workflow in future releases. Also create database schema graphically, and have them actually generate custom objects instead of your having to use the current form field based system to design custom objects.

I welcome your comments on any of these videos or suggestions about others that you think are not to be missed. Now I'm glad I didn't race into SF for that 7:30am session I really wanted to catch, but not badly enough to get up that early. Now it's just a click away anytime I want to reference it.

Labels: CRM, Database, How-To

It is a common misunderstanding that cross-object workflow is not possible in SalesForce.com CRM. It is extremely limited and in my experience tends to only work the way I don't usually need it to work, but there is some cross-object functionality.

Say for example you have created checkbox fields on both Contact and Account records to mark them as Active or not. One might logically want the Account to be marked as "active" whenever any related Contact record is. Unfortunately, the workflow formula you need will only allow you to mark the Contact record as "active" whenever a related Account is. Not too helpful.

I will teach you the method, then leave it up to you to find useful applications in your work. To perform the above workflow between Contacts and Accounts you would do the following:

1. Go to Setup/Create/Workflow&Approvals/Workflow Rules and create a new rule.
   
2. Start with the Contact object, because you will be updating a field on that object, and you cannot do field updates across standard objects.
3. Under field criteria, choose field "Account: Active" and operator "Equals" and value "Yes"
4. Hit Save and next (after naming the rule of course and making sure it is set to trigger upon creation, edit, etc. as you desire)
5. Create the workflow action "new field update"
6. Enter the naming you desire and set the field to update to be the field called "Active"
7. Specify the new field value of "yes"
   

You can also create the workflow rule that uses this field update by using "formula evaluates to true" instead of "criteria are met" under the rule criteria. The advantage of doing this is that sometimes more objects are available through lookup relationships when using the formula rather than just the drop-down lists of fields.

Here are a couple of examples that may actually be a bit more useful to you. These come from SalesForce's help files:

Update Case record based on values on related Account record:

Send email alert when Case is created related to certain Accounts, based on field values on the Account record:

A final note from SFDC help files on when and how you can use field updates with workflow rules:

"For standard objects, workflow rules can only perform field updates on the object related to the rule. The exceptions are that both Case Comments and Email Messages can perform cross-object field updates on Cases. For all custom objects, however, you can create workflow actions where a change to a detail record updates a field on the related master record. Cross-object field updates only work for master/detail relationships."

I welcome your sharing of other useful cross-object workflow rules you have been able to create among standard SalesForce objects. This is hopefully an area that SFDC intends to build out further in future releases. For example, I think a lot of people would love to be able to update status fields on Contact or Opportunity records whenever certain Tasks are marked as "Completed." I can think of dozens of helpful use cases for more cross-object workflow. Right now we are pretty much dependent on very limited native functionality and Apex coding to go beyond that.

Important Addendum: I was remiss in leaving out an important caveat about doing cross-object workflow. Note that even though the rules will work across the objects, you won't actually get the ones on the resultant object to fire until it is edited. It doesn't matter what change, if any, is made to the record, but the rules won't evaluate on object A simply because object B was edited, even if it is the new criteria on object B that cause it to meet object A rule's criteria.

AspiraTech has developed Aspira Xobject as a solution to this problem. Using Aspira Xobject, which is available for download on the AppExchange, you can connect any two objects so that workflow rules on one get evaluated whenever the other is edited. Check it out.

Labels: CRM, How-To

Even if today's posting of leaked Twitter confidential information that was accessed through Google Docs has filled you with apprehension about relying on that platform for any sensitive parts of your business, hopefully you are not hesitant to use some great low-threat features like Google Calendar. SalesForce just put out a very straight-forward and instructive how-to video on integrating your Google Calendar into SFDC, and having it display on your home page instead of the SFDC internal calendar.

With this feature, if you have 20 employees sharing a Google calendar, but only 10 using SFDC, you can still see a calendar within SFDC that represents the entire company's calendar.

Link to: Google Calendar Integration How-To video

Labels: CRM, How-To, Integration, SaaS