Hi Everyone,
I would like to join a custom object to the standard company object, so I can use the company's object fields in a report. Also, I tried to "enable lookup" the field that I want to use in the report, but I can't find the custom object, see attached screenshot.
Page 1 / 1
Hi Neftali,
If you wanted to see the Company object's fields when you create a report on your custom object you would actually need to go about it the other way and enable the lookup on a custom object field.
Go the Edit view for the field in your custom object that you want the join to be based on.
Then similar to what you've done above, "Enable Lookup" and then look for the Company object.
You can then select the field to join on (in your case the Vertical field in the Company object).
This will then give you the option to select fields from Company in your report based on the field that your join is based on.
Hope this helps!
Thanks,
Kunal
If you wanted to see the Company object's fields when you create a report on your custom object you would actually need to go about it the other way and enable the lookup on a custom object field.
Go the Edit view for the field in your custom object that you want the join to be based on.
Then similar to what you've done above, "Enable Lookup" and then look for the Company object.
You can then select the field to join on (in your case the Vertical field in the Company object).
This will then give you the option to select fields from Company in your report based on the field that your join is based on.
Hope this helps!
Thanks,
Kunal
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.