The continued battle between NPSP vs NPC

Up until a year and a half ago, nonprofits using Salesforce had only one choice. They would start with Salesforce, and then install the Nonprofit Success Pack (NPSP). Today more than 50,000 nonprofits actively use it.

Then Salesforce introduced the Nonprofit Cloud (NPC).… Read the rest

Passing the Salesforce security review

Towards the end of your Salesforce app development, you’ll start shifting your focus on how to list it. There are two main ways to list an app:

  1. As an unlisted app
  2. On the Salesforce AppExchange

As an unlisted app, you simply need to share a published link with your client.… Read the rest

Deciding what features to include in your Salesforce app

When starting to build an app, you probably have tons of ideas about which features to include. But once you start talking to prospects and clients, be open to their feedback. It’s not easy to think of every feature your clients need, and if your clients want something, they will let you know.… Read the rest

Why build a Salesforce app

Salesforce consulting is awesome. There are thousands of Salesforce partners that do it, from single person shops to agencies with thousands of employees and/or subcontractors.

You can build an entire career as a consultant and maintain it until you retire.

However, there are some drawbacks.… Read the rest

Creating fake data for demos

As a Salesforce consultant, you’ll often have to host demos of your work to your client. Demos are only useful with data, so at some point, you’ll need to create some.

Now, I’ve heard of an interesting story with a valuable lesson.… Read the rest

Why MS Access is awesome for data transformations

Like Salesforce, MS Access uses a relational database. This means each Access table can represent a single SF object. And once in Access, you have multiple tools at your disposal for data transformation.

The first step is to export data from SF and import it into Access.… Read the rest

Salesforce data management tool

A number of readers asked me for more information about the Salesforce data management tool I built.

It’s basically a MS Access database with a Salesforce Dataloader integration. This means it can be used to:

  • Export data from Salesforce directly into an MS Access table
  • Insert, update, and delete data from a MS Access table to Salesforce

Additional features:

  • Single screen for a better user experience
  • No more playing around with .csv
Read the rest

Cleaning up the data model

One of my favorite Salesforce activities is cleaning up technical debt. With one of my current clients, we’ve been moving data from custom fields to standard fields and objects.

For example, the contact object had the following:

  • A field called Organization, which is different than Account
  • Custom fields called Assistant1, Assistant2, Assistant3, as some people had 1, 2, or 3 assistants
  • 7 recordypes, which all used the same different layouts, but the same fields were displayed

The account object had:

  • A custom field called Street, City, Zip, and State, because they didn’t like the label Billing Address or Shipping Address
  • Sometimes was the name of a contact, as they only reported on accounts.
Read the rest

Something to be thankful for

Today is Thanksgiving in Canada. While it’s not as huge of an event as in the US, it’s still a significant moment.

The origin of the celebration is to give thanks for a good harvest. Since most of us are not farmers anymore, we extended the moment of gratitude to include friends and family.… Read the rest

A peer review without comments

The other day, a friend told me a funny story. He was asked by a colleague to review their work before merging it into the main development sandbox.

The colleague started by explaining the purpose of the feature they designed and built.… Read the rest

Salesforce as an AI company

If you haven’t already noticed, Salesforce is really pushing their AI advancements.

Like really pushing.

I believe they started labelling last year’s Dreamforce (their annual conference in San Francisco) as the “largest AI event in the world”. This year was no different.… Read the rest

Simplifying tax season: the power of a SOP

As an independent Salesforce consultant, I need to submit my taxes to the government on a quarterly basis. This means having a platform in place to record my invoices and expenses.

Since I provide a service, I need to charge local tax on my invoices.… Read the rest

Recommended vs suggesting apps

You understand that Salesforce, as great as it is, has limits. That’s why the AppExchange exists. To provide third-party organizations an opportunity to fill those gaps or improve upon core functionality.

However, as a Salesforce consultant, there’s a fine line between recommending an app and suggesting one.… Read the rest

Salesforce or bust

My friend’s wife approached me earlier today to learn about Salesforce.

She is the owner of a small art consulting business, advising businesses and high net-worth individuals about which art installations to buy and why.

Last year, she purchased a Salesforce license and was now looking to implement it.… Read the rest

What about updating field names?

When you name a field, there are two definitions to consider

  1. The field label, which is shown to your users
  2. The field name (or API name), which is the technical name used by systems

When you rename either of these definitions, Salesforce pops a warning message.… Read the rest

How not to name Salesforce fields

In today’s tech Tuesday article, let’s discuss field names.

I’m currently auditing a client’s data model. The team created the following roll-up fields:

  • Number of Occupied Spaces
  • Number of Unoccupied Accessible Spaces
  • Number of Unoccupied Female Spaces
  • Number of Unoccupied Male Spaces
  • Number of Unoccupied Spaces
  • Total Spaces

A couple of issues strike me immediately:

  1. The naming convention isn’t consistent.
Read the rest

What to do when you’re on the bench

As a Salesforce consultant, how should you spend your time when you don’t have much work to do?

This is a common question that is becoming more and more relevant as work is harder and harder to find. Whether you’re a full-time employee of a consulting agency or an independent contractor, the answer is mostly the same.… Read the rest

Salesforce talent ecosystem report for 2024

10k is a Salesforce agency in the US. Over the last few years, they also publish annual reports about the state of the Salesforce ecosystem.

In short, this year’s report doesn’t look great. They call it a “post-COVID hangover.”

Here are some notable takeaways:

  • Salesforce’s growth has slowed
  • Global demand for Salesforce talent has dropped 37%
  • Demand for Consultants declined by 43%, the largest decrease in demand across all roles
  • Technical Architects and Solution Architects were both close behind at 41%
  • There is a 19% increase in the global supply of Salesforce talent

So demand has gone down while supply increased.… Read the rest

What are sprint stretch goals?

So you’re doing the agile thing during your Salesforce project. Your two week sprints are full of user stories. Each user story is allocated points, which represents the level of development complexity and ultimately, the time to deliver the story.

The project manager (PM) usually knows how many points can be delivered in an average sprint.… Read the rest

Client demos after the sprint

When working in sprints, there are two common ways of demonstrating work to a client. The first is during the sprint, which eats up time for actual development.

The second is after the sprint is finished. This is an interesting choice, as your team has more time to deliver more functionality than option 1.… Read the rest

Managing client feedback during a sprint demo

The sprint is complete and you’ve delivered several user stories and points. Yay to the team for their accomplishments. Now it’s time to show off their hard work.

As a Salesforce consultant, it may very well be your responsibility to demo this work.… Read the rest

Why Salesforce projects need more time than you think

When you’re delivering a Salesforce project, you’re probably using a form of agile methodology. It’s the popular kid these days.

Work is usually migrated from a Development (DEV) sandbox to a Quality Assurance (QA) sandbox every two weeks. Towards the end of the sprint, you’ll probably want to demonstrate to the client what was done in that sprint.… Read the rest

The secretary problem

While at a local Salesforce user group event yesterday, a colleague spoke about how he received several new opportunities. This is obviously a good sign, as recently Salesforce opportunities are harder to come by than in the past.

The challenge he’s now facing is deciding which opportunity to choose from.… Read the rest

Using a design decision framework

When you have several solutions to a Salesforce problem, how do you make a final decision? How do you recognize and fight for the best solution?

Enter a framework. A framework is a series of guidelines and considerations to help you make the right decision for a specific problem.… Read the rest

Your first idea usually isn’t the best

There’s a phenomenon in psychology called anchors. An anchor is usually the thing you think most often of, when presented with a stimulus.

For example, if I ask you to think of a tool, your first thought is probably of a hammer.… Read the rest

Cleaning out your storage locker

Earlier today, I helped a friend clean his storage locker. He’s been holding onto things for far too long, and needed someone to help him discard things.

Being a minimalist, I told him to throw away, recycle, or donate nearly everything.… Read the rest

What’s your backup plan?

Yesterday, a colleague accidentally factory reset their mobile phone. She was jet lagged and didn’t fully realize what she was doing until it was too late.

As a result, she lost hundreds of notes, contacts, pictures, and other important information. None of this data was being backed up into the cloud.… Read the rest