how to filter by child records Scott Carpenter October 11, 2022 15:53 Updated Needs to create a view for parent records to be filter by child records. Long Zhao shared this idea · Mar 21, 2016 Related articles After I imported the first spreadsheet I could not figure out how to import the other 3 use a calculated field return the latest entry from a child table Set up a multiple layered conditional filters? Sort by name in Calculated field? Calculate a fields value at record creation time, but not update it ever again Comments 1 comment Sort by Date Votes Tiffanie Staver October 26, 2022 18:06 Alex commented · March 21, 2016 11:04 AM Hi Long, This is a difficult concept because a parent has many children that have many different values which can be filtered many different ways for the one parent record. In this case, the best way to accomplish this is to determine what children you wish to mark and separate from the others for the parent to look at. For example, an if statement in the child table can be used to pull those records out: if(status= complete, 1,0) so that only my completed children are identified. Then the parent can sum this if statement to get a number of completed children. You can then filter the parent based on this new sum being greater than 0. You can now see your parent records where they have completed children. Please let us know if you have any questions! Regards, Alex 0 Please sign in to leave a comment.