Hi All,
Hope you're having a lovely day!
My organisation has several teams and projects each with different data fields that they want to collect against accounts (organisations) and contacts. Importantly, the structure of the organisation can change drastically based upon external funding, so teams and projects can be created or ceased meaning that the needs can change drastically.
Traditionally when they had additional fields they would add them to the Contacts entity or Accounts entity (a big no-no as it means those tables grow enormously). Aside from capturing this information outside the CRM, I've been wondering if there was a way to meet this need in the CRM. The best idea I have so far is developing custom entities specifically for the the team's needs that we can hide later on (using security settings) if the team changes or project ends. From my limited understanding, it should be possible to link the custom entity to a contact or account record using a connection so we can ensure that the information is linked to the account in some way (I'd imagine it would only need to be a one-to-one relationship in most cases).
I'm open to other ideas on how to address this need if anyone has any advice?
Thanks,
Andrew J.
*This post is locked for comments