WeDid: Custom Validation Rules on Child Records

Challenges

The client would like to ensure that all the child records of a master record to be marked as “Completed” before the users can change any a specific value in the master record.

Solution:

Ensure that the master and child record objects are linked using master-detail relationship.

Use a roll-up summary to calculate total child records and use roll-up summary to calculate total child records with “Completed” status.

Use validation to check if these 2 roll-up summaries match. If matched allow the changes of a value in master record if not then otherwise.