Is there a way to create a hybrid field that displays either the Owning Business Unit (User) or Owning Business Unit (Team) on an Entity?
If the record is owned by a team, I want to display the owning team's business unit in a view.
Likewise if the record is owned by a user, I want to display the owning user's business unit in a view.
I know I can add two columns to my view Owning Business Unit (User) and Owning Business Unit (Team).
However, this creates problems.
I want a single column in all views of all entities that simply says Owning Business Unit and the BU will be there regardless of if the record is owned by a User or a Team.
The records will always be changing business units and I need to ensure we don't add any extra processes to the platform that would constantly update the record with a new business unit. I simply want to display the current BU in a SINGLE COLUMN in every view for every record as opposed adding TWO columns to each view where one will be blank and. the other will contain data.
Is there a way to do that without creating a custom field name Business Unit and writing a workflow or custom plugin that determines the BU and inserts it into that field?