Simplifying Salesforce: Tackling Cross Object Merge Fields in Email Templates

Imagine you’re a chef trying to prepare a gourmet meal, but your ingredients are scattered across two different pantries. This is the challenge Salesforce users face with cross object merge fields in email templates. Currently, Salesforce doesn’t allow direct use of data from related objects in email templates. It’s like having to run between two pantries to gather your ingredients, making the cooking process (or in this case, email creation) unnecessarily complicated.

How to Workaround it

So, how do we solve this culinary conundrum? The current workaround in Salesforce is akin to setting up a small prep station (a hidden formula field) in your main pantry (the parent object). Here, you temporarily place items (data) from the second pantry (child object). This way, you can use all the ingredients you need for your recipe (email template) without the back-and-forth.

Here’s how to set up your prep station:
1. **Create a Hidden Formula Field**: In your parent object, create a new formula field. This field will act as your ‘prep station’, holding data from the child object.
2. **Transfer Data from Child to Parent Object**: Use this formula field to reference the fields in the child object you need in your email template. It’s like moving ingredients from the second pantry to your prep station.
3. **Build Your Email Template**: Now, when you create your email template, you can use these formula fields as merge fields. It’s like having all your ingredients within arm’s reach, even though they came from different places.

Understanding the Limitations

While this workaround is helpful, it’s not without its limitations. For example, if you’re trying to bring over a long or rich text field, you might hit a roadblock since formula fields have character limits. It’s like trying to fit a large pot on a small prep station – it just won’t work.

As a last resort,  Visualforce Email Templates break through most limitations encountered by both Classic and Lightning Email Templates. However, they require more of a development background to set up.

SOLVD: Your Salesforce Solution Partner

At SOLVD, we understand the challenges and intricacies of Salesforce. Our approach is all about finding efficient, cost-effective solutions to such problems. If you’re grappling with Salesforce limitations above or need expert guidance, check out our services at SOLVD. We’re here to help you ‘cook up’ more efficient solutions in Salesforce!

yellow cloud solvd logo

Our clients say

From my initial call with Spencer through project implementation with John and Evan, my experience with the SOLVD team was excellent. They were quick to understand our business needs, clear when explaining the reasoning behind proposed solutions, transparent when reporting on progress and timeline, and all around enjoyable to work with. Would highly recommend and looking forward to continue working with them in the future!

Veronica Wong Director of Operations at Pathstream

SOLVD was very straight forward with everything needed to complete the project. No surprises, no issues, and cost was aligned with the estimate. They made implementation easy and quick.

Matt Benzaquen Sr Manager, Sales Strategy at Instabug

As a rule, I'm pretty stingy with my recommendations. So it's a pleasure for me to recommend Solvd as a top-flight Salesforce consultancy. Solvd recently led our company's conversion to the Lightning interface and did it on time, on budget and made it easy for me and my team. I know I'll use their services again, and am confident they can do the same for you.

Tim Tuttle CFO at Relevate Health Group