Computer Associates Plans To Release Agile Development Tool On Force.com Platform

November 19, 2009 by David Schach · Leave a Comment
Filed under: Development, Partners 

Today, at Dreamforce 2009, Computer Associates plans to release CA Agile Planner(http://www.ca.com/agile), a tool to manage agile development teams.
CA Agile Planner will be integrated with CA Clarity PPM (http://www.ca.com/ppm).

Although it was not clear how much of the demonstrated app will run on Force.com and how much will run on the CA servers (though it appeared to be 100% on Force.com), it was clear that the application was accessed via a force.com URL.

For more information, see http://www.ca.com/agile.

A release date for the product was not mentioned, but the earliest planned release of any newly-announced feature thus far is Spring 2010, so one might assume that this will not be available until then.

 

Trigger to help Salesforce for Twitter

October 6, 2009 by David Schach · Leave a Comment
Filed under: salesforce.com 

Salesforce for Twitter is one of the best AppExchange packages I've seen. It fulfills the promise salesforce.com made to bring the Service Cloud to all orgs of all sizes. And it works well.

Though a supplemental/unofficial guide to customizing SFDC for Twitter will be released soon on this site, I wanted to share a trigger I just wrote to add new Leads to a campaign:

Firstly, thank you to Scott Hemmeter at Arrowpointe, who wrote the original code that I customized.

Secondly, you could easily duplicate this trigger and set it to run on the Contact object as well.

Please don't set the trigger to "after update," as in testing, it ran into problems when converting a Lead and merging with a Contact already on the "Twitter" campaign.

trigger AddToTwitterCampaign on Lead (after insert) {

    // List containing each Lead being processed
    list<Lead> theLeads = new list<Lead>(); 
      
    //We only execute if we have a campaign named "Twitter"

    if([SELECT Count() FROM Campaign WHERE name = 'Twitter'] == 1){
        Campaign TC = [SELECT id, name FROM Campaign WHERE name = 'Twitter' LIMIT 1];
        
        for(Lead l:trigger.new) { 
            if (l.leadsource.indexOf('Twitter',0 ) >= 0 ||  l.leadsource.indexOf('Tweet',0 ) >= 0 ){  
                theLeads.add(l); // add lead to the main lead list
                }
            }
      
      // List containing Campaign Member records to be inserted
      list <CampaignMember> theCampaignMembers = new list<CampaignMember>(); 
    
      for (Lead ld:theLeads) {
          CampaignMember cml = new CampaignMember();
          cml.leadid = ld.id;
          cml.campaignid = TC.id;
          theCampaignMembers.add(cml);
        }

     //Insert the list of Campaign Members
      if(!theCampaignMembers.isEmpty()){
        insert theCampaignMembers;
        }
    }
}

The trigger requires that you have a Campaign called "Twitter," but feel free to change that to anything else you'd like.

Don't worry if you have other triggers that add Leads to Campaigns - this can work alongside them, so you can add Leads to as many Campaigns as you'd like.

 

Filtered Lookups, Validation Rules, and Order of Execution

Reading the cheatsheet for Filtered Lookup (beta), I noticed an interesting line:

Lookup filters function similarly to validation rules when you save a record. That is, actions that cause related records to save, such as changes to a roll-up summary fields, also trigger the lookup filters on the related record and block the save.

The implications for this are massive. Let's explore two examples:

Example 1: Filter as Validation Rule from Parent Record

  • We create a lookup on a Child object to Parent.
  • We filter the lookup to EXCLUDE Parent.Status = 'Closed' (Parent.Status is only Open or Closed.)
  • We can edit the Child records as long as the Parent Status is not Closed.
  • When Parent.Status is changed to Closed, existing related Child records are not affected...
  • BUT if we attempt to edit a Child when the Parent is Closed, Force.com will throw an error (which we can customize) beause that the Lookup is invalid.
  • (and clearly we cannot add new Child records either)

Conclusion: Thus, Filtered Lookups act much like Validation Rules. A quick experiment shows that Filtered Lookup errors actually fire before Validation Rules.

Example 2: Filter as Validation Rule on Roll-Up Summary (from Child Record) - what the line above was referencing

  • Use the above example, but change the lookup to a master-detail relationship
  • Create a Roll-Up Summary field to count all child records
  • Prevent saving more than 10 child records for one parent record

Here, we have triggered a filter error without touching a parent record, yet we throw an error based on a value on the parent record.

This second example is significant because we could already prevent more than 10 child records from saving, but doing so required a Roll-Up Summary field on the parent object AND a Validation Rule on the child object. Now we can replace the Validation Rule with the Lookup Filter, though we still need the Roll-Up Summary field. Whether or not this simplifies things is definitely up for debate...

Conclusion

This is a very powerful feature! Thanks to salesforce.com for rolling it out, even in beta form.

Real world example: The above example would be great for Time Sheet Entry and Time Sheet Header objects, as they would create, in effect, a validation rule on the Header record preventing editing of any child records. Awesome!

For further reading, check Salesforce Help's Lookup Filters examples.

 

Preparing a New Org

With the impending arrival of the Winter 2010 (aka 162 or Winter'10) edition of Salesforce CRM, as with every other release, comes a prerelease org. (You can get one at https://www.salesforce.com/form/trial/prerelease_winter10.jsp.)

Every time one encounters a fresh org, there are maintenance tasks to perform. I usually go through an org (whether a Developer Edition org or a Prerelease version) and do the same tasks, generally in no particular order. This time, however, I wrote down what I did as I did it. Looking at the list, it's hardly in any "best practices" order at all - it's just how I did it.

There's no need to follow every step, and it is not a complete list of all possibilities, but this should give you some idea of the possibilities and available tweaks: (*** indicates some of the new features in WInter '10)

  1. Save login with 1Password/Roboform
  2. Reset (Set) Security Token
  3. Administration Setup | Security Controls
    • Session time 8 hrs
    • Passwords never expire
  4. Create Record Types (and Business Processes) for Lead, Opportunity, Case
  5. (Campaigns were not enabled in this prerelease org) - would have configured them here, similarly
  6. Activities section: Calendar link on sidebar
  7. Download latest versions of Connect for Outlook, Office Edition
  8. Opportunities:
    • Enable Similar Opportunities
    • Enable Opportunity Teams
  9. Create Account Master Record Type
  10. Enable Account Teams
  11. Create Contact Master Record Type
    • Note: Asked to add to page layout. Not asked for Opportunities.
  12. Enable Case Teams
  13. Enable Public Solutions
  14. Solutions:
    • Enable Solution Browsing
    • Enable Solution HTML
    • Could have created a Solution Process & Record Type
    • Did not enable multilingual solutions
  15. Enable Self-Service
  16. Enable Web-to-Case
  17. Create default Owner, etc (auto prompted)
  18. Enable PRM and Partner Portal (though have no licenses)
  19. Salesforce to Salesforce
    • Enabled S2S
    • Set up S2S Connection Finder ***
    • Added fields to page layout - Kept read-only for all profiles except System Administrator
    • Enable Public & Private Tags
  20. Enable Console for all Profiles
  21. Search Settings - Enable Enhanced Lookup & Auto-Complete
  22. User Interface
    • Separate loading of related lists
    • Spell Checker on Tasks & Events
    • Collapsible Sidebar
    • Custom Sidebar on all Pages
    • Enhanced Profile Management ***
  23. Set myself as default Workflow User
  24. Looked at Develop | Custom Settings ***
  25. Created a Default Queue and added myself
  26. Set all Sharing Rules to Private
  27. Update Home Page to the way I like it
    • Order of wide section (top down): Calendar, Tasks, Items to Approve, Dashboard
    • No changes to narrow section

Other things that may be possible in other orgs:

  • Enable Customer Portal
  • Customize Campaigns
  • Set up Sites

Again, this is not meant to be a complete list. Also, it is not intended to be a how-to; for more information you may search the Help link at the top of every org page, check Salesforce Community, or Developer Force.

Happy configuring!

 

« Previous PageNext Page »

  • Recent Posts

  • Subscribe

  • Post Categories