Hello! I'm dealing with some polymorphic fields, and have been breaking them out to separate custom columns for each type:
WHEN [owner_type] is 'Organization' THEN [Owner_id]
and another custom column:
WHEN [owner_type] is 'User' THEN [Owner_id]
Then I link the fields with the other tables (org.id and user.id) for Org ID or Org ID, to be able to get their actual names
I'm finding this isn't working great in the bigger picture, I would like to put a custom field expression that does it all at once.
So I have a single column that returns either the org.name or user.name linked to the owner_id depending on the owner_type column, thus reducing the number of columns, and eliminating having so many null entries in both columns.
How do I do that? Can I do that? :D
Please sign in to leave a comment.