I am trying to take the "Email" field on Contact records and concatenate it onto the "Related Contact Emails" field (long text field) on the related Account. I would like to have the email addresses separated by a comma.
Ideally, this field would update when a contact is added/newly-related to an account and removed if the contact is no longer related to that Account.
Is anyone aware of how this can be done!?