Clever Workarounds for Salesforce's User Lookup Limitation

The Current Landscape: What's Happening Now

As of now, Salesforce does not support adding a lookup field directly to the User object. This limitation has sparked a lot of discussions and requests for change in the Salesforce community. Users have shared various scenarios where this feature could significantly enhance functionality – from tracking user affiliations to organizations, to simplifying license management, and even improving data integrity in reporting.

Workarounds: A Lookup Without a Lookup

While Salesforce has not yet implemented this feature, there are some workarounds that can help manage these challenges:

Using Text Fields and Picklists

   – Scenario: You want to link users to a specific company or department.

   – Solution: Create a text field or a picklist on the User object that references the company or department. This method, while not ideal, can serve as a temporary solution to maintain some level of data consistency.


Custom Objects and Junction Objects

   – Scenario: Linking users to a specific club or organization.

   – Solution: Create a custom object to represent the club or organization and then use a junction object to link users to this custom object. This approach is more complex but offers a more robust way to manage relationships between different entities in Salesforce.


Utilizing External Tools or Apps

   – Scenario: Complex relationship tracking, like license management.

   – Solution: Sometimes, the best solution lies outside of Salesforce’s native capabilities. Exploring apps on the Salesforce AppExchange or custom-built tools might provide the functionality you need.


Looking Ahead: What's Next for Salesforce Users

While these workarounds offer temporary solutions, the Salesforce community continues to advocate for a more integrated feature. Salesforce has acknowledged this need but has also indicated that this feature is not a priority in the immediate future. However, they encourage users to continue providing feedback and use cases, as these will influence future prioritizations.

In the ever-evolving landscape of Salesforce, staying ahead of challenges and embracing innovative solutions is key. SOLVD, a dedicated Salesforce consulting firm, understands these challenges intimately. With a focus on providing top-tier, cost-effective solutions, SOLVD is well-equipped to help navigate these complexities and optimize your Salesforce experience. Discover more about how SOLVD can assist you by visiting SOLVD.
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