Skip to main content

I have a custom object called Additional Properties.  For each additional property an account has I create an additional property record.  The additional Properties records have a field to identify TYPE of additional property (ie. Type1, Type2, Type3)

 

I'd like to create EITHER of the two scenarios: 

 

1.  A number field on the account level that counts how many additional properties records are associated with the account that are Type1 or Type2 (and doesn't include Type 3). 

 

OR 

 

2.  A checkbox field on the account level that is checked off if the account has Type1 or Type2 (it doesn't matter if they have Type3 so ignore it) additional property records

 

I'd prefer the first option  #Sales Cloud

2 respostas
  1. 27 de ago. de 2021, 14:13

    Hi Rachel,

     

    Is the relationship a master-detail?  If so you could use Rollup fields for scenario 1.  Create rollup field on account that is of rollup type Count.  Then filter to just count Additional Properties of Type1.  Then repeat this with another Rollup field for Additional Properties of Type2.

0/9000