A new knowledge base article has been published on our support portal.
In this scenario our business requirement is that when an accounts address is updated you need to update all the related contact addresses with the same data. The scenario involves the synchronization of fields between entities where a one to many (1:N) relationship exists.
However there are up to 200+ contacts and the syncing will take too long to process in real-time, therefore we want to run this process asynchronously in the background.
N52 Formula Manager Solution
The Formula Manager solution works like this:
- We create a formula that fires for just updates on the account entity where any of the address fields change
- The formula itself retrieves all the contacts associated via the parentcustomerid field on the contact entity
- It will then loop over all the contacts and update the address information with that of account entity