+ Start a Discussion
Philip BonthaPhilip Bontha 

Formula field to make the checkbox true on parent object if the child object Lookup(User) fields are not blank

Hi Experts,

I have a reuirement where we have to make the checkbox as true on parent object if the lookup(user) fields are not blank on child object.
For example I have a checkbox field Check__c on parent and I have multiple Lookup(user) fields like User1__c,User2__c,User3__c on child object.If all the three user fields are not blank then the check__c field should be true,if any one of the User field is blank then the check__c field should be false.

Thanks in advance..!

Regards,
Raju
RituSharmaRituSharma
You can't achieve this using formula. If you create formula at child level, you can access fields of parent but not the other way. You will need to create flow/trigger to populate the flag at the parent level.
Neha Srivastava 4Neha Srivastava 4
@Philip We can not create a formula on Parent object to fetch Child object. Create a flow use get record and compare the total number of child records and number of child record which the checkbox checked.
If both are same, update the Parent checkbox accordingly.