Skip to main content
New Idea

Enforce SFDC referential constraints within Gainsight lookup fields

Related products:None
  • December 30, 2016
  • 4 replies
  • 23 views

josh_grigone
Hi all,

It recently came about via the support channel that, when linking an Opportunity to a CTA, for example, we only respect searching on a specific opportunity id when we are linking to an existing one.

If you want create a newOpportunity or want to populate the same Opp in one of the fields on a CTA, it will search by name and fetches all the opportunities within the opportunity object. It appears this is essentially ignoring the lookup filter. If a user has a referential constraint in SF, shouldn't this be enforced within the UI?As an example - say we have 1,000 accounts and each account has 0 - 5 opportunities and we link the opportunities to their account. When selecting opportunities to link to, we should be limited to those 0-5 opportunities respective to that account, rather than all opportunities, correct?

It seems that we allow a CTA to be linked to an Opportunity that belongs to a different customer. Shouldn't the lookup only search for Opportunities that are linked to the specific Customer/Account object that the CTA is linked to?

Thanks!

4 replies

nitisha_rathi
  • Expert ⭐️
  • 1134 replies
  • January 2, 2017
Hi Josh,

I agree, we are planning to fix this by spring release.

Thanks,
Nitisha

karl_rumelhart
Forum|alt.badge.img+4
  • Helper ⭐️⭐️⭐️
  • 460 replies
  • January 2, 2017
While I agree that linking a CTA to an Opp would most often happen within the same Account -- this is typical and should be the default -- I would be cautious about being too rigid here.  Indeed, it can easily happen that an Opportunity is on the 'wrong' account, especially with renewal Opps.  

Consider the following:  a large Corporation includes many Companies inside it (think: Disney Corp includes Disney Theme Parks, ESPN, etc.).  A business Relationship may be with one of these companies but the Contract may be held at a parent or even a 'sibling' company.  (Some corporations have separate IT Companies that often hold contracts.)  From a Finance perspective it can be important that a Renewal Opportunity be on the Account that holds the contract.  But this might be totally irrelevant from a Sales or CSM perspective.  So you could definitely have a situation of a CTA on a Customer  -- the one that actually uses the product -- which makes sense to link to an Opportunity on a different Account -- the one that pays for the product.

Broadening the discussion a bit, this difference in what makes sense from a Finance, Sales and CSM perspective, is a really common challenge.  It is what so often leads people to say things like 'our hierarchy is broken.'  Thing is, rigid constructs like Accounts and Hierarchies simply can't model the variety of things that you need to model to satisfy all of the important perspectives on your customers.  (Which is 'right', orienting by Users, by Buyers or by Payers?  Really, all of them!)  This is part of the motivation for our Relationships capability.  Instead of running around and trying to agree on some phantom 'correct' Account structure, just keep things simple at the Account level and model the different perspectives with Relationships (of different Types).  And because the core concept in Relationships is *association* rather than *hierarchy* you have huge flexibility to link things together in ways that capture what is true about how you relate to the customer. 

srinivasa_pulagam
Hi,

We do honor Acount Id filter while searching for records to link to a CTA( Search performed with Name and Account Id combination except for Case where case number is used instead of name). This is the whole reason why we ask to select Account reference field to be used in Cockpit configuration if there are multiple Account lookups for the linked object .



Thanks,
Srinivas

steven_doty
  • Contributor ⭐️⭐️⭐️
  • 24 replies
  • July 24, 2018
Hi, I have a contact lookup field in the C360 Attributes section and our end users are unable to find the admin quickly because we have so many contacts. Is there any way that this request can be revived?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings