• Mesme Bestwick 15
  • NEWBIE
  • 0 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Contact has a multi select custom field called Role__c which can have values (Surgeon;Nurse;First Assist;Admin;CSR). Account has a custom field called Total_Score__c which is a number field. Mapping table Role_Score__c looks like this Role__c Score__c
Surgeon 10
Nurse 5
First Assist 10
Admin 0
CSR 20
When a contact is created/updated, get total score of all the UNIQUE roles that exist on all the contacts of the account.
Ex: Account 1
Contact 1 with roles Surgeon;Admin
Contact 2 with roles CSR:Admin
On Account 1 we should store the value as (10 + 0 + 20 = 30) because we only have 3 unique roles.