Skip to main content
phaneendhar_lingam
phaneendhar_lingam
Contributor ⭐️⭐️⭐️
July 16, 2020
New Idea

Lookup on Standard and System objects from Custom objects

  • July 16, 2020
  • 8 replies
  • 199 views

Hi team,

 

We often create custom objects to bring together data from multiple standard/ system objects for various customer usecases.

For example, to merge data from Timeline and SuccessPlan together. In these cases, we are pulling all the required fields from both Timeline and SuccessPlan objects.

Instead, if there’s a lookup on to these objects based on the GSID field, we can  pull the required fields based on the available lookups.

Our custom objects and rules become very compact if GSID is utilised fully for cases like these.

    8 replies

    pgeorge
    Gainsight Employee ⭐️
    pgeorge
    Gainsight Employee ⭐️
    August 4, 2020

    @phaneendhar_lingam Most of our Standard objects are Low Volume objects.

    Look ups are allowed to standard objects but the data volumes should match.

    Can you let me know the standard objects you are trying to create lookups from and the volume type of your custom objects?

     

      phaneendhar_lingam
      phaneendhar_lingamAuthor
      Contributor ⭐️⭐️⭐️
      August 11, 2020

      I’m targeting success Plan, Call to Action, Scorecard Fact, Timeline objects - I’ll be using GSID as the lookup field. 

      sai_ram
      sai_ram
      Expert ⭐️⭐️
      October 13, 2020

      I’m targeting success Plan, Call to Action, Scorecard Fact, Timeline objects - I’ll be using GSID as the lookup field. 

      @phaneendhar_lingam Thanks for the update! we are looking into the feasibility. I will update you here once I hear from product team. 

      ssamarth
      Gainsight Employee ⭐️
      ssamarth
      Gainsight Employee ⭐️
      January 5, 2021

      @phaneendhar_lingam  what is the volume type of your custom objects?

        phaneendhar_lingam
        phaneendhar_lingamAuthor
        Contributor ⭐️⭐️⭐️
        February 2, 2021

        Hi @ssamarth - These sorts of custom objects are mostly of high volume.

          ssamarth
          Gainsight Employee ⭐️
          ssamarth
          Gainsight Employee ⭐️
          February 2, 2021

          @phaneendhar_lingam Look ups are allowed between custom & standard  objects if the data volumes match of both.

            sai_ram
            sai_ram
            Expert ⭐️⭐️
            February 23, 2021

            @phaneendhar_lingam did you get a chance to view the comments here?

            phaneendhar_lingam
            phaneendhar_lingamAuthor
            Contributor ⭐️⭐️⭐️
            March 3, 2021

            Hi @ssamarth - from an implementation point of view, this is a helpful feature.  The volume of data that we handle is relatively lower (at least when compared to traditional relational databases) so it shouldn’t be a problem.

            Terms & ConditionsAccessibility statement