Accounts - Subtract number field when Contact is remove from Account

Question

I created a flow and process builder when a Contact is added to an account, number "1" will be added to the Number_of_Contacts__c number field in Accounts. I created these features based on this website - https://www.xgeek.net/salesforce/create-roll-up-summary-field-to-count-contacts-on-account-with-process-builder-and-flows/

Also when the Contact is deleted, number "1" will be subtracted from the Number_of_Contacts__c field in Accounts.

However here is the issue I am experiencing, when I reassign a contact from one account to another account, the Number_of_Contacts__c field values in the original account does not update.

For example, if I add Contact A to Account A, the Number_of_Contacts__c field = "1" . When I remove Contact A from Account A and add it to Account B, Account A Number_of_Contacts__c field still = "1". It should remain blank.

Is there a way to resolve this issue?

If there is a way to solve this issue without using Apex coding?

If the solution is to use Apex, does anyone have an example of using anApex Trigger and an Apex Class?

Harsh Patel · Accepted Answer

Hello Forrest,   Here is a solution which will definitely work for you:    https://success.salesforce.com/answers?id=9063A000000e0GiQAI   http://www.dhruvsoft.com/blog/displaying-total-number-of-contacts-for-each-account-in-salesforce/

Harsh Patel · Answer

Please visit belove link for test class.   https://developer.salesforce.com/forums/?id=906F0000000AqgKIAS

Accounts - Subtract number field when Contact is remove from Account

Customer Service

Related Learning

More Help