Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
adding a calculated field to accounts view RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a custom entity with a 1 to N ( accounts = 1  and oacc N)

    is it possible to in a view to put the number of oacc records for each record in the account view 

    ie in accounts name = fred

    in oacc there are 5 records for fred

    in the accounts view can i get

    name count Oacc

    fred        5

    Dont ask me .. i dont know

    Wednesday, July 31, 2013 5:38 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Nothing out of the box that will handle this. 

    You would need to take an approach like creating a new field on the parent entity to hold the value (so it gets displayed in the view) and then creating plugins on the various messages of the child entities to sum them up and update the field on the parent record. 

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Wednesday, July 31, 2013 6:05 PM
    Moderator