Sforce Maximizer

Updating master object field with most recent child objects record in salesforce crm..

If you are using salesforce crm, one of the challenges is to update master object fields with most recent record child record field. E.g would be updating  opportunity field with most recent quote amount, updating most recent email preference for your contacts based on their response e.tc. Here are possible solutions and options.

Solution

1.Using process builder and workflow rules, you can update the master object field when the child object is created or modified.

2. Visual flow

3. Apex triggers

Things to consider

When your master records are deduped and merged, your master record dependent field will not have the most recent record of the child because salesforce merges do not trigger any workflows. To solve this, copying the child record field to the master record as a separate field and showing a report on discrepancies could help proactively identify the record and then you have to manually fix the records.

The second option is to have apex triggers which would fix the master record on updates which would query the most recent child and fix them..

Feel free to post your comments below on this thread or contact me at buyan47@gmail.com for further questions..

 

Exit mobile version