Kevin Brammer

How to concatenate Salesforce.com picklist fields with a formula field

Kevin Brammer — Sat, 21 May 2011 18:14:27 +0000

I just discovered how to combine the values from several different Salesforce.com lead picklist values into one field by creating a formula field. Picklists have special restrictions when it comes to using them in formulas. Although the final solution was pretty straightforward, I struggled with this until I found this helpful link. Here is the formula I used to check if the picklist value is empty before adding it to the formula field:

IF(ISBLANK(TEXT(CustomPicklistField1__c)),”None”,TEXT(CustomPicklistField1__c)) &
IF(ISBLANK(TEXT(CustomPicklistField2__c)), “”, ” – ” & TEXT(CustomPicklistField2__c)) &
IF(ISBLANK(TEXT(CustomPicklistField3__c)),”",” – ” & TEXT(CustomPicklistField3__c))

Playing with Pano for iPhone

Kevin Brammer — Fri, 23 Jul 2010 02:24:21 +0000

I am really enjoying this panoramic photo application. It allows you to line up several photos with the help of a clever overlay feature, and even works in portrait or landscape mode. The results are surprisingly good even though the photo resolution is decreased to fit within the maximum allowable width. Here are some examples:

Crazy Ivans – Dive!

Kevin Brammer — Sat, 27 Feb 2010 17:33:03 +0000

I finally finished the artwork for The Crazy Ivans and I am really pleased with the results. It was a lot of fun to start painting again. Trying to get just the right “underwater” lighting and color scheme was challenging but a really interesting project. Plus, it is always fun to throw in a couple of creepy underwater monsters. I had just finished reading 20,000 Leagues Under the Sea so it was a given that there had to be lots of tentacles and at least a hint of a lost civilization Unfortunately, my laptop was stolen soon after I had the artwork printed so I don’t have the original artwork anymore. I was able to salvage some of my work from email thank goodness. Take a look and let me know what you think, and go to The Crazy Ivans MySpace page to listen to some great music!

The Crazy Ivans - Dive! CD Cover

The Crazy Ivans - Dive! CD Label

The Crazy Ivans - Dive! Inside CD Cover

The Next Serif Trend

Kevin Brammer — Sun, 27 Sep 2009 15:31:57 +0000

Web Designer Wall has a good collection of sites that use serif fonts in The Next Serif Trend. Exciting to see sites beginning to venture out from the standard web safe font collection!

Google News with Fast Flip

Kevin Brammer — Sun, 27 Sep 2009 14:54:08 +0000

I often read Google News on my iPhone, so you can imagine my excitement when I discovered the new fast flip feature. Need the link? Just Google it ;-P

WordPress for iPhone

Kevin Brammer — Tue, 31 Mar 2009 06:15:53 +0000

Okay I think it’d time to jump on the band wagon and start using WordPress for my blog. The app for iPhone is just what I have been looking for! The worst part is migrating content from the old blog and redirecting traffic, but it has to happen sooner or later right?