@gunjanm any idea about this?
There is no other solution to do. You have to add additional fields.
Your only other solution is to duplicate the Relationship multiple times, but that in itself will cause problems.
Having a Team Member object would be ideal. And yes sure you can create that concept. However, that will cause issues when you go to dashboard/report filters and displaying them.
There is no other solution to do. You have to add additional fields.
Your only other solution is to duplicate the Relationship multiple times, but that in itself will cause problems.
Having a Team Member object would be ideal. And yes sure you can create that concept. However, that will cause issues when you go to dashboard/report filters and displaying them.
This is exactly it. Just have multiple lookups to the User object. It will be easier rather than harder to report on, to be honest. We’ve got multiple types of CSMs on the Company and then different Relationship Types (which could be an option but still causes equivalent difficulty/complexity).