A free resource for certification.

No longer posting on site

leave a comment »

Quick note- if for whatever reason you are still getting this feed, please update! This feed is now inactive!

Click here and update your RSS Feed!


Written by John Coppedge

October 8, 2009 at 12:12 am

Posted in Uncategorized to [Migration]

leave a comment »

I haven’t been posting as frequently lately, and with good reason:  I’ve been busy.  Work has picked up with new projects (including some interesting work), I’ve had a ton of stuff going on in the offline world, and I’ve been studying.  I’ve been preparing for the developer, consultant, and advanced administrator exams.  Stay tuned, you can expect some materials in the not too distant future.

Migrating from to a self-hosted solution was surprisingly easy.  I purchased the domain previously through a provider, the process is likely more complicated if you purchased a domain directly through WordPress.

  1. Add a hosting package to your domain (usually 5-10$/mo).
  2. Export your blog.
  3. Change nameservers on the domain to your web host.
  4. Install WordPress on your web host.
  5. Import the file created in step #2 into your newly hosted blog.

I set up a hosts file entry on my local pc so that I could access and configure the site completely before the nameserver changes made the site live to the rest of the world.

That’s it for now!  Cheers,


Written by John Coppedge

October 8, 2009 at 12:07 am

Posted in Site Updates

Google Apps and Salesforce Web Integration Review [Not ready for primetime?]

leave a comment »


I spent some time recently playing with the Google Apps and Salesforce integration.  This product overview will get you a pretty good idea of how it works.  However, the demo leaves out a few critical shortcomings:

Read the rest of this entry »

Written by John Coppedge

September 30, 2009 at 2:12 am

Winter ‘10 Salesforce Preview Webinar Wrap Up

with 2 comments


For those of you that missed the Winter ‘10 webinar yesterday, here’s what you missed!  A recorded version should be available next week at


New Platform Features

Read the rest of this entry »

Written by John Coppedge

September 16, 2009 at 6:58 pm

Posted in New Releases

Tagged with , ,

Another Resource for Developer Certification [Dev 401 Exam Tips]

with one comment

Check out the Salesforce Made Easy blog for some certified developer exam advice, including 45 practice questions!

Written by John Coppedge

August 27, 2009 at 11:02 pm

Enlist AutoIT to Perform Data Manipulation [Tips & Tricks]

leave a comment »


When you work with data, sometimes you need your own personal data masseuse (I could use one for my back too!).  Thoughts like “if only I could put all of these entries on one line“ or “now if only I could put a space in every 15 characters” or “if I have to hit the blank key followed by the blank key any more blanking times, I am going to blank someone” often creep to mind.  The good news is that you can build a tool to tackle a lot of these repetitive tasks using AutoIT, and the language is very accessible.



Compressing a list into a shorter comma-separated list (used this for mass transfer accounts wizard when names did not match exactly and did not have IDs):


The very simple code to make this happen:


All I would do is run this script and hop into notepad at the start of the file.  You can change the loop settings to match the length of the file, and of course make any changes to keystroke combinations.  You can even get fancy and program it to automatically change to notepad.  I was more comfortable with granular control.



The are an infinite number of ways to use this program.  With a little imagination and some basic understanding, this can be another great tool to add to the toolkit.

I would recommend downloading the AutoIT Full Installation and the Script Editor.  I’ve also included the sample script shown above:

AutoIT Download Page

Sample Script

Check out the online documentation, and here is a good introduction including a list of commonly used keys.  Happy scripting!

Written by John Coppedge

August 27, 2009 at 4:17 pm

Surveys & Salesforce: SurveyGizmo Delivers Powerful Options [My 2nd Favorite Web App]

with 7 comments


I haven’t mentioned this yet on the site, but I am a HUGE fan of Survey Gizmo.  This is easily my second favorite web app, Salesforce of course taking the top slot on my mental podium.  My standard response around the office these days has been "Can’t we just put that into Gizmo?".  This could be because we do a ton of surveys (we could conceivably bump up against the 50K/mo response limit of our enterprise account), or it could be because of the awesome flexibility of the product.

We recently added our telemarketing department into our Salesforce org.  We added accounts, then got them placing orders using opportunities.  Then we added historical orders through an opportunity import, which is how the need for the Find and Replace Template arose.

Telemarketing then says they need to perform follow up surveys after orders are completed.  I think- sweet, I’ve got exactly the right tool.  And then I remember that very tool has a Salesforce integration feature I’ve meant try for some time.

So here was the approach I took:

1) Create link to survey on the opportunity page.  Link only works if the opportunity is complete, and the survey has not been completed.  Notice the link passes the opportunity ID and owner ID to the survey.  Here’s the formula:

IF(TEXT( StageName )="Complete", IF(LEN( Survey_Result__c ) > 0, "Survey Has Been Completed", HYPERLINK(""&Id&"&OWNER="&OwnerId,"Take Survey","_self")), "Survey Results Not Ready")

2) When the survey is completed, link the opportunity to the survey results.
The first page of the survey takes the passed variables and creates hidden fields with both variables.  The last field is a link to the current survey result.


This last field is used to update the survey result field (URL) in Salesforce, linking the Salesforce opportunity to the survey result:


During the survey a question is asked to determine if there should be follow up with the client.  In Gizmo, you can create a date field by using a text field and setting date validation in the options of the question.  This also allows me to create a follow up task on the opportunity.


3) Redirect from survey back to the opportunity

This shouldn’t anywhere near as hard as it is.  The problem is that Gizmo’s web redirect uses the "?=" format which will not fly for a Salesforce URL.  I called support on this one, and they suggested hard coding a redirect in raw HTML on the final page.  After being put on hold for a minute, they said this couldn’t be officially supported.  That’s OK.  They planted the seed, I just spent some time holding the watering can.  By testing the length of the ID field, I was able to prevent the redirect from triggering unless survey was passed from Salesforce (otherwise the redirect will trigger even when you are editing the survey – rather inconvenient).

Redirecting to Opportunity
<script language=javascript>
var test="[%%28:Opportunity ID  %%]"
var result = test.length;

if (result == 15)
  window.location = " ID  %%]"



This is just one example of the combo in action.  Others could include:

  • Auto-sending a survey when a SalesForce case closes.
  • Creating a web-to-anything form without code.
  • Building forms using Salesforce data (I am looking into building a checkout portal using Gizmo as a front-end to Salesforce data and then pushing this data to a service such as Roman Cart).
  • Email survey invites to Salesforce contacts (would require an export/import, will hopefully become fully integrated) and push survey result(s) into contact record.


Nothing is perfect.  Here are a few issues I have discovered during use:

  • Data exports of 20k+ records are often so slow that the browser will time out (IMO there should be an email to download link method of delivery).
  • Reporting lacks some flexibility: color choice of graphs, text occasionally overlaps, cannot remove summary text, etc. (hopefully will be addressed with new reporting package, release date TBD).
  • Use of hidden fields to store data fields is messy (this doesn’t impact functionality; an alternative would be a data field type that was never displayed, and was always ordered last on the page).


Despite these issues, if you use Salesforce (EE/UE) and have a need for forms/surveys, this is definitely a product to try.  Click here to give it a shot!


Full disclosure: I am entered into the affiliate program; if you sign up for an account I will get your first month’s payment.  That said, I would be just eager to recommend the product without any financial incentive, so why miss out?

Written by John Coppedge

August 25, 2009 at 10:33 pm