If you’ve ever worked with Salesforce, you know how powerful “lookup fields” can be for connecting records across objects. Now, HubSpot has its own version of lookup fields—allowing you to link data between standard and custom objects in a flexible way. This is a game-changer for modeling real-world business relationships without locking yourself into a rigid structure.
The caveat? As of today, creating lookup fields typically requires API calls. But at Resonate, we built a free tool within our 0CodeTools app for HubSpot that puts a user-friendly interface on top of these new capabilities. So now you can create lookup fields—no developers or code required.
A lookup field in HubSpot is a property on one object that references a single record in another object. For example, a custom object called “Policy” could have a lookup to a “Company” record, linking each Policy to its respective client. Or a “Project” custom object might reference a “Contact” record as the “Project Sponsor.” HubSpot also supports adding lookup fields to standard objects like Deals or Contacts, so you can reference a related record as needed.
Key note: HubSpot currently allows one record per lookup field—unlike Salesforce, which can support many-to-many relationships through junction objects. In other words, you can’t select multiple related records in a single lookup property. If you need to tie multiple records, you’ll need either additional lookup properties or a different approach.
You typically need to define your lookup properties through HubSpot’s API, which can be time-intensive if you’re not a developer.
Our free app adds a point-and-click interface for creating lookup fields—no API calls, no scripts. If you can fill out a simple form, you can create and manage these new relationships in minutes -> get started at https://tools.resonatehq.com
While Salesforce provides robust lookup relationships, we’ve adapted some of those best practices for HubSpot’s current one-to-one lookup constraints:
1. Use Lookups for Optional or Independent Relationships: If you want to associate two objects without forcing them to always depend on each other, a lookup field is perfect. For instance, a “Contract” record in HubSpot might link to a “Company,” but it can stand alone if you’re still drafting it and don’t know the final client.
2. Make Key Properties Required at the Right Time. HubSpot’s Deal stages allow you to require certain properties before moving a deal forward. For example, if you have lookup fields for “Budget Holder” or “Decision Maker” (which might reference a specific Contact), you can require reps to fill these fields before moving the deal to a “Negotiation” stage. This ensures your team has identified the right stakeholders early in the process.
3. Avoid vague property names like “Lookup 1.” Instead, use “Primary Supplier,” “Policy Holder,” or “Budget Holder.” Provide help text so users know exactly what they’re linking to.
4. Don’t Overdo It: Although HubSpot doesn’t enforce a strict limit on how many lookups an object can have, each additional lookup is one more property to fill out and maintain. Stick to what’s essential for your business processes
One of the most practical uses for lookup fields in HubSpot is on the Deal object. You might create:
When the deal moves from “Qualification” to “Proposal,” you can make these fields required. That way, your sales reps can’t progress without identifying the right individuals. This not only improves data consistency but also ensures your team never forgets crucial stakeholders during a complex sales cycle.