Comments for X-Squared On-Demand

Comment on Standard Checkbox Images by Checkbox Formula Field in Visualforce : X-Squared On-Demand

Checkbox Formula Field in Visualforce : X-Squared On-Demand — Thu, 16 Jul 2009 14:50:22 +0000

[...] keeping with the theme of checkboxes and formulas, we provide an easy way to create a checkbox formula field using Visualforce: the [...]

Comment on Email Inbox Version 2 by Jeff Douglas

Jeff Douglas — Thu, 16 Jul 2009 10:19:02 +0000

Oh Snap!!! Excellent work!! Very impressive.

Comment on Visualforce Email Inbox by Email Inbox Version 2 : X-Squared On-Demand

Email Inbox Version 2 : X-Squared On-Demand — Thu, 16 Jul 2009 01:41:43 +0000

[...] The Apex controller code has not changed from Version 1. [...]

Comment on Visualforce Email Inbox by Email Inbox Version 2 : X-Squared On-Demand

Email Inbox Version 2 : X-Squared On-Demand — Thu, 16 Jul 2009 01:41:43 +0000

[...] The Apex controller code has not changed from Version 1. [...]

Comment on Visualforce Email Inbox by Kyle Roche

Kyle Roche — Wed, 15 Jul 2009 14:45:50 +0000

Nice job David. I’d be interested in the screenshot / link as well. Good stuff.

Comment on Visualforce Email Inbox by Jon Mountjoy

Jon Mountjoy — Tue, 14 Jul 2009 18:06:03 +0000

Can you include a screenshot of the app? How about a link to it running on Sites on a Developer Edition? :-)

Comment on Convert between Business and Person Accounts (B2B B2C) by Understanding Business Accounts and Person Accounts - Part 2

Understanding Business Accounts and Person Accounts - Part 2 — Wed, 27 May 2009 06:09:13 +0000

[...] is the code courtesy of David Schach of X2OD.com: {!REQUIRESCRIPT(”/soap/ajax/13.0/connection.js”)} var AccountObj = new sforce.SObject(”Account”); [...]

Comment on Convert between Business and Person Accounts (B2B B2C) by Jon Cline

Jon Cline — Tue, 26 May 2009 21:53:42 +0000

I’m a huge fan of you right now! :D

This is so much easier than the data loader.

I am working with non-profits who love Person Accounts as it is cumbersome at best to deal with all Donors as B2B accounts with Contacts.

Comment on Pulling Code Out of Triggers by Jeff Douglas

Jeff Douglas — Fri, 22 May 2009 21:21:12 +0000

David, thanks for taking my crappy code and making it better. I won’t receive a bill will I? I find your reasoning sound and have been refactoring a number of triggers in this same way.

Comment on Pulling Code Out of Triggers by Dave Manelski

Dave Manelski — Tue, 19 May 2009 01:40:01 +0000

We have a few classes with methods used by multiple triggers. In lieu of passing the trigger set (sObjects), we’ve opted for passing primivitive data types only between triggers and classes, purposefully to reduce dependencies. In your example, I would probably opt for passing a list of strings (for the Ids in the trigger set) and perform a SOQL in the class.

By keeping these dependencies to a minimum, you can easier package code, among other benefits. I’ve adopted this “best practice” based on observation and advice of more talented coders than myself so I’d be curious to find out how someone with formal computer science training weighs in on this.

Comment on Pulling Code Out of Triggers by David Schach

David Schach — Mon, 18 May 2009 20:37:57 +0000

I was just thinking about something similar today – with some logic and passing a String parameter, one could use the same class to update a single field to multiple values. For instance, an opportunity trigger to Account.Type -> Customer if total won opp value is >0, and -> VIP Customer if total won opp value > 250,000.
The possibilities are limitless!

Comment on Pulling Code Out of Triggers by Scott Hemmeter

Scott Hemmeter — Mon, 18 May 2009 20:11:41 +0000

I use this approach with a slight mod.

I have 1 trigger for each object and it fires for all events where I have code. Example of my Leads trigger below. It’s basically what you are suggesting, but it’s one common trigger and I add if/thens based upon the event that is firing.

This way there is 1 trigger and 1 class for each object.

trigger Leads on Lead (after insert, after update) {

// AFTER INSERT
if(Trigger.isAfter && Trigger.isInsert){
Leads l = new Leads();
l.CreateCampaignMembers(Trigger.new);
}

// AFTER UPDATE
if(Trigger.isAfter && Trigger.isUpdate){
Leads l = new Leads();
l.setOpportunityDefaults(Trigger.new, Trigger.oldMap);
l.transferOpptyFromLeadToAccount(Trigger.new, Trigger.oldMap);
}

}

Comment on Pulling Code Out of Triggers by Jeremy Ross

Jeremy Ross — Mon, 18 May 2009 17:11:55 +0000

I prefer to keep triggers very lean and free of business logic. I’d probably disagree with commenting your class with which triggers call it, for a few reasons. 1) The class shouldn’t know or care who calls it – the beauty of reuse, 2) someone will inevitably create a new client of the class and not update the “users” comment in the class, 3) this is related to 2, which is you’ll have a false sense of security of who is using the class.

The “show dependencies” button on the apex class screen would be infinitely more useful if it would show dependents instead of dependencies.

Comment on Standard Checkbox Images by Scott Hemmeter

Scott Hemmeter — Tue, 12 May 2009 00:30:41 +0000

I don’t know how to get that. I just knew this example because I have dealt with it before. What I typically do is look around Salesforce for images I like and use them. Copying them is just fine too.

Comment on Dashboards are Improved AND New in Summer 09 by Thomas Tobin

Thomas Tobin — Mon, 11 May 2009 23:15:22 +0000

Using the color-blind palette is a user preference – you set yourself as color-blind, and the alternate palette is used for you when you look at reports and dashboards.
If you are fine with the standard palette, then you just don’t need to set the checkbox.
The standard palette was tested on our in-house color-blind guinea pigs and they were mostly ok with it. They felt that the color-blind option was clearer over the range of colors (you can only see the first three in the ramp in the screenshot above).

Comment on Standard Checkbox Images by David Schach

David Schach — Mon, 11 May 2009 20:40:03 +0000

Great point, Scott. Do you know where we can get a list of the contents of the /img/ and /img/samples/ directories?

Comment on Standard Checkbox Images by Scott Hemmeter

Scott Hemmeter — Mon, 11 May 2009 20:34:21 +0000

Or use the relative link “/img/checkbox_checked.gif” or “/img/checkbox_unchecked.gif” and don’t store them yourself.
And make sure you tell your users that you can’t report on this field being true or false. It’s just for display.

Comment on Dashboards are Improved AND New in Summer 09 by Werewolf

Werewolf — Fri, 08 May 2009 06:29:31 +0000

The funny thing is that I’m color blind (red-green), and yet the regular color scheme seems easier on my eyes then the color blind scheme.

Comment on Hacking a Case Comment Trigger by Stan

Stan — Fri, 24 Apr 2009 15:31:15 +0000

I dropped you the complete code that provides a CaseComment trigger. In response to your question, you can access the Case Comment (which actually caused the Case trigger) using the ParentId field in the CaseComment object. It is the Id of the Case record. The SOQL to get the LMD of the Case Comment is: “CaseComment aCaseComment = [SELECT LastModifiedDate FROM CaseComment WHERE ParentId = :C.Id ORDER BY LastModifiedDate DESC limit 1];”. Get the Case LMD using this: “Case aCase = [SELECT LastModifiedDate FROM Case WHERE Id = :C.Id];”. Then do the comparison: “if (aCaseComment.LastModifiedDate >= aCase.LastModifiedDate)”. Put your code to handle a CaseComment trigger inside that “if” statement. Be sure your code handles the potential exception where the Case has no Case Comments or your users won’t be able to make changes to any of their cases.

Comment on Hacking a Case Comment Trigger by David Schach

David Schach — Wed, 22 Apr 2009 21:21:58 +0000

That is an interesting approach, and I can certainly see uses for comparing the LastModifiedDate in other scenarios!
I think I see where you’re coming from: Because CaseComment will also execute any Case triggers, you are comparing those dates. So by editing the Case Comment, it will trigger on the Case. That’s great. How do you query the LMD of the CaseComment record if the trigger sits on the Case? I’m having trouble visualizing it; would you like to post your code or send it to me so I can post it with proper formatting? Feel free to use “Send a File” in the Contact Us section.
Thanks for the comment!