A new Foundation in my career

Two weeks ago, I joined the Salesforce Foundation in a new role as Open Source Manager.

What exactly does that mean? Well, I could tell you about how I’m on the Foundation’s Tech & Products team (specifically on the product engineering side) and how it’s all about working with the broader community and the Foundation to evangelize and grow investment in open source projects. But I think this about sums it up as far as most community folks are concerned, at least for right now:

Best so far:

  • I’m being paid to engage with the Salesforce nonprofit community (seriously, how cool is that?!?).
  • This is an amazing time of change and growth for the Foundation and I’m excited to be a part of it.
  • My teammates are brilliant, funny and have made me feel at home immediately.
  • After 3.5 years where my work computer was a Windows PC with Exchange/Outlook, I’m back to being productive on Mac OS X and Google Apps. This MacBook Air is sweet.

Will take getting used to:

  • It’s a very big company. I have to learn how to swim in the ocean and have a little more patience with myself as I do.
  • Leaving KELL Partners was tough. I truly enjoyed working there and I learned so much.
  • Joining the Foundation means saying goodbye to Salesforce MVP. I was fortunate and honored to be selected as an MVP for 5 years and that community will always be dear to me.

As I was loading up WordPress to write this blog, I was curious so I searched through my 1,982 posts to find I mentioned Salesforce in 133 of them (that’s it? I did think it would be more). There was a time before Facebook, Twitter and Salesforce Chatter where this blog was my primary channel to communicate with the world. I found the first post where I talked about Salesforce.

From April 6, 2006:

After looking at more software products aimed at the nonprofit world than I can count, including hosted platforms and even a custom-designed solution, what did we decide on? Salesforce.com.

Salesforce.com is an incredible CRM. Extremely powerful, extremely configurable … Out of the box, we couldn’t possibly consider or afford the package, running at $1,500 per year per user. However, Salesforce.com has a foundation where they give away licenses to qualified nonprofits! Completely free. No strings attached except that you have to use it to keep it. So I opened a trial account and started reading and learning and the more I read and learn, the more I like what I see. … I completed the paperwork to apply for their grant, which was awarded earlier this week, so now we’re all set with 10 licenses of the Enterprise edition.

I had no idea when I posted that 9 years and 1 month ago that I was beginning the most meaningful and exciting phase of my career. I’ve enjoyed the reaction as folks have learned that I joined the Foundation. That it was meant to be. I love that.


Using Salesforce Process Builder & Flow with Opportunity Contact Roles

This came out of a discussion (and Idea Exchange idea) on the Success Community around Process Builder’s inability to work with the Opportunity Contact Role object.

There are two common requests I often get related to Opportunity Contact Roles, both now solved easily with clicks instead of code thanks to Flow and Process Builder!

  • Automatically create an Opportunity Contact Role record based on a lookup field on the Opportunity
  • Automatically populate a lookup field on the Opportunity with the Contact who is the Opportunity’s Primary contact role

Note: be careful with active Processes when doing bulk data uploads – it’s not bulk-ready and even these simple updates can cause you to hit limits.  Update as of Winter ’16 release: Process Builder is now bulkified!

Continue reading

Will Judi ever update her blog again?

It’s kinda sad when a blog looks abandoned, isn’t it?

When I started blogging way back in January 2003, there weren’t a lot of other places where I could communicate and express myself publicly. My blog picked up in popularity in the early years because there weren’t that many of us with blogs compared to those who were reading them.

It was because of this blog that I had the amazing opportunity to write for GigaOm and I got noticed in the nonprofit Salesforce community. I will be forever grateful.

Certainly, I have no plans to take the site down, thanks to free WordPress.com and the marginal yearly cost to maintain the domain. There’s over 10 years of content here (nearly 2,000 posts) that still pops up in Google search results from time to time. And who knows, maybe I’ll pick up the blogging bug again some day.

In the meantime, you can find me on the Power of Us Hub (if you’re a Salesforce user in the nonprofit world), the Salesforce Success Community, Ravelry (if you’re addicted to yarn like I am) or Twitter. I also write occasional articles on KELL Partners’ website.

If you want to email me directly, the contact form here is still the best way to get in touch. I do reply to every message that isn’t spammy/marketing.


What “The Internet of Customers” means to me

I’ve spent the last few days at Dreamforce 2013 thinking about this year’s theme: The Internet of Customers.

What does it mean to the nonprofits I support? What does that have to do with CRM? I don’t want to just introduce my clients to a new mobile app – I want to show them why it matters. I want to drink the Kool Aid and share it.

This morning I received an email which led me to a bit of a revelation:

Hello Webmaster,

We had approached you on dated October 13th, 2013 for remove our back links from following links.

(links removed)

It has been past almost one week and neither link has been deleted nor any confirmation from your side. Again we are requesting you to remove link or we have only option to approach for disavow tool.

Disavow tool may be harm to your website so please remove back link and confirm us.

Softweb Solutions

I’m not honoring this company with another backlink – they’re easy enough to find if you’re curious to see a company still living in 2003 and not 2013. This isn’t a startup fly-by-night. This is a big company serving the enterprise space.

I replied, to express a bit of a WTF but mainly to see if a real person sent the message. He replied and said he “understood my situation” but his manager made him do it.

The link in question was on a comment at the bottom of a 5 year old blog post. The comment itself was “Thanks for this information” and the URL of Softweb Solutions. Truth be told, I typically delete such useless drivel right away as blog spam. Guess that one slipped through in 2008.

I was mad. First, I don’t like being threatened. (who does?) Does it look like I care about the disavow tool? I’ve long stopped monitoring where my blog comes up in search results. When I have something I want to say I post here, and when people who care about what I post want to read what I post they come here and they read it. If they really like it they’ll post a link on their own networks. That’s all I look at. If it comes up in Google, all the better. I don’t remember the last time I looked at traffic stats.

But then I thought about it and it made me sad for poor sorry Softweb Solutions. They don’t get it. This is a technology company in 2013 serving the enterprise with expertise in every tired technology, and they are clueless about what it means to be a customer company. And they shouldn’t be clueless. No business or nonprofit can afford to be clueless about the direction we’re heading.

I’m not their customer, and probably never will be. I’m sad that they saw a link buried in a comment on a 5 year old post and decided that I had no value as a potential customer or partner. They didn’t know that I recommend technology to many others, including some who work for or connect with some very large companies. They didn’t know that I have 1,000 more followers than their company Twitter account does. They apparently decided based on one old page on this site that I was a detractor to their success rather than an opportunity. And that’s sad.

And here I am, posting a blog saying bad things about this company and there’s no disavow tool they can threaten me with to make this go away. People who follow me might be looking for exactly the service that Softweb Solutions offers and their first impression of the company may very well be someone else’s negative insight.

That’s the Internet of Customers, isn’t it? Everyone who touches your brand, even if it’s in a buried and forgotten blog post by some tiny person, is your customer or constituent. Are you going to threaten them with disavow or make a positive impact? Your choice.

A customer company would have known that I’m so much more than a blog that doesn’t get enough love.

Dear Softweb Solutions: I was more than happy to mark that useless ancient comment as spam. You don’t deserve to have a link here.

Open Letter to Salesforce Nonprofit Admins

In the 20 months since I left Fight Colorectal Cancer, I would guess that I’ve logged in to no less than 150 nonprofit Salesforce organizations. First as part of my role supporting customers at Convio/Blackbaud, and now in my role at KELL Partners where I work with clients who contract with us for support or virtual administration services.

When trying to troubleshoot a problem, one of the first things I typically look at is how the organization has structured their security and sharing model. Profiles, roles, organization-wide defaults, sharing settings. I’m thrilled to say that I’ve logged in to many organizations where the System Administrator is truly that – someone whose is responsible (and accountable) for the way Salesforce works for everyone else. Someone who protects the data and their configuration. Someone who knows where experimentation is okay and where they need to tread lightly. If that’s you, then thank you – this post isn’t for you. But please read on and comment on anything I’ve missed, okay?

For this post, I’m talking to the organization whose Manage Users looks something like this (yes, this is from a real org I won’t mention by name):


Read on and I’ll explain exactly why it’s a very bad idea, and I’ll give you some suggestions on what to do to protect your organization’s data and your sanity.

Continue reading

Smartsheet: Frustrated with online project management no longer

smartsheet1It’s been a while since I posted anything that wasn’t related to Salesforce, hasn’t it? Here’s something a little different, but still cheerleading technology and tools I like, which I used to do a lot more of.

Over 3 years ago, I wrote a blog post about my quest to find decent project management software for Fight Colorectal Cancer. That post was quite popular for a while and still gets a fair number of page views. Commenters either sympathized, or used the post’s page rank to promote their own wares.

Right around the time I started at KELL Partners last year, I helped our team implement Smartsheet as our main tool for keeping track of timelines, requirements and deliverables with clients and internal projects. Truth be told, had Smartsheet existed in this form 3 years ago, I wouldn’t have been so frustrated. It meets all the requirements I mentioned in that post and then some.

Right now we have 389 active sheets in our Team account. I’ve been asked a few times, “Why Smartsheet? Why aren’t you just using Google Docs?”

Yes, some of what we’re doing in Smartsheet could be done in Google Docs. But aside from the fact that KELL doesn’t use Google Apps so documents wouldn’t be centralized and owned by the company, Smartsheet does so much more than just flat spreadsheets. Every time I use it, I find some cool new way to make it work better.

What is Smartsheet? It’s an Excel/Google Doc-like online app that generates spreadsheets that are more dynamic than just rows & columns. In addition to spreadsheets, there’s quite a bit of Microsoft Project thrown in (it can even import Project files). The interface is very simple to learn and use, which makes it ideal for sharing with clients of all technical backgrounds. You need a paid account to create sheets after the free trial expires. But those sheets can be shared with anyone, either through a named user or through a publish link that anyone can view if they know it.

Here’s why I think Smartsheet is a better choice than Google Docs for team collaboration, so I can just point to this post in the future.

Continue reading

Introducing Apsona batch gift entry for the Nonprofit Starter Pack

Over the past few years I’ve come to appreciate the Salesforce Foundation’s Nonprofit Starter Pack (NPSP). But I have to admit, I’m not a fan of the Foundation’s Batch Data Entry tool. The interface is clunky and it doesn’t proactively allow you to create donor records on the fly or apply payments to an existing opportunity record. It was released in 2011 and hasn’t appeared to get a lot of love since. It’s not mentioned on the main Starter Pack page or in the documentation.

While Common Ground’s batch tool was far from perfect, a lot of organizations used it and relied on it. At KELL Partners, we couldn’t migrate them to a NPSP-based solution without a decent batch gift entry solution. It’s not just uploading Opportunity records via the Data Loader or DemandTools. You have to match those gifts to existing donors or create new ones if they don’t exist. You have to make sure those gifts aren’t already attached to pledges. And you have to know enough about your data to map the field name and values correctly.

We thought about developing our own utility that ran in the Salesforce UI (like the NPSP batch tool or Common Ground’s). We considered developing a stand alone tool (like DemandTools). And then the light bulb went off. Apsona!

Apsona already had a UI starting point. It’s all about manipulating data. It runs separately inside of Salesforce but is not a separate download. And there aren’t enough words to say how highly we regard Apsona’s leadership, Sridhar and Sadna. We knew they’d be a pleasure to work with (and they were!). We approached Sridhar and Sadna in late January/early February with the idea of developing a batch gift entry tool together. They agreed without hesitation and here’s the result! We spoke to many of our clients and evaluated how batches are entered in many different applications, in and out of Salesforce. I’m very proud of this collaboration. This initial release came out even better than I imagined it.

Continue reading