Skip to main content
I am evaluating Lightning Connect. I have been able to connect to OData and retrieve specific information about my Account. When I do this, the information displays as a Related List on the Account object. What I want to do is take specific fields from OData and place those on the Account object, so they can be accessed through an Account view, report, etc. Is that possible?
1 answer
  1. Feb 28, 2016, 8:32 PM
    Hi

    As far as I know you can't directly do that.

    I was thinking about creating a external object mapped to your external data (ex: Account__x), relating Account__x with Account standard object through an external lookup, and creating formula fields in Account standard object referencing your Account__x fields, but formula fields don't support external objects by now, so, that's not possible either. Then I guess you will have to override account layout with a visualforce that shows the fields you need to see, those from your Account and those from its related Account__x.

    There is an idea for showing related objects fields in layouts, which you can vote (https://success.salesforce.com/ideaView?id=08730000000BrXVAA0).

    Regarding to reports, you can create reports that show related objects fields, so, that shouldn't be a problem.

    If I find out anything else I will write to you.

    Hope it helps, and best regards!
0/9000