Accounts list view show field from latest open opportunity

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • johncarmichael
    Junior Member
    • Oct 2017
    • 2

    Accounts list view show field from latest open opportunity

    Hi there,

    New to this CRM, so far so good. A current code base unlike zurmo, so no sign of it becoming a dead end and totally customisable, only took 15mins or so to get to grips with it all.

    We have a requirement though, is it possible to add a dynamic field to the accounts object from the opportunities?

    Our business works on a yearly membership business model, as such we generally only have one opportunity on the go for any given account at 1 time.
    What we would like to be able to do is pull out the latest opportunity related to a given account and display a field in the list view.

    ie: in the screenshot below we would like to add the current status of the latest opportunity to the list view of the accounts thus giving us an easier overview of the opportunities and accounts in one page.
    Last edited by johncarmichael; 10-09-2017, 08:04 AM.
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    Hello
    I see two ways, how to do this

    first one (can be done with UI only, but if you have Advanced Pack) - you need to create a new relationship between account and opportunity (many to one). After opportunity save Update related entity Account, set opportunityId as target opportunity ID. And also you need to create a foreign field for Account, related to new relationship.

    second one (with little coding) - you need to develop a function, where you fill the needed field (http://forum.espocrm.com/forum/devel...inkmulti-field http://forum.espocrm.com/forum/devel...in-an-relation)

    Comment

    Working...