Last time, you learned about the object network and the bridges — instance fields! — that create connections between them. Single instance fields are the simplest version of that bridge.
In this issue, you learn about the two ways to use these fields to cross it 🤓 Chances are, you already know one of them! You just haven’t seen it defined this way.
Let’s set the scene.
First, identify your instance fields
Say you’re building an Advanced report on the Worker business object. For your columns, you want fields related to each worker’s job and location — including whether they sit at a location you classify as Headquarters, Satellite, or Remote.
But there’s a problem 😬
The field that holds those values — Location Type — doesn’t live on Worker. It’s part of the Location business object.
Report definition for an Advanced report type pulling in worker job and location-related fields with an empty slot for “Location Type”.
So how do you retrieve that data per worker?
This is where the good stuff lives.
Free builds awareness. Premium fills all the gaps 🦄
Below:
How to find the right instance field
How to access related business object fields inside an Advanced report — no calc field needed
Why that same move doesn't work in Matrix reports or condition rules — and the calc field that fills that gap
Plus everything else in Premium:
⭐️ Release Ratings & Reviews
🔐 Full archive access
🗳️ A say in what gets built
