Is there a childconcatenate formula with if? I want to add quantities in the child table only if they fit a criteria in another field Scott Carpenter October 10, 2022 23:15 Updated Wei Jia shared this idea · Sep 8, 2017 Related articles Can i create a custom form that adds multiple records to a table? Complete List of Functions Comments 1 comment Sort by Date Votes Tiffanie Staver October 21, 2022 21:07 John McGarvey commented · September 8, 2017 9:29 AM I don't believe there is an If condition from the parent because the childconcatenate looks at all child records as one group, and not individually, But, you can add your If condition on the child table for each record, then use that new child conditional field to concatenate up to the parent. Example child table:If(Field 1) = condition, True Value, False Value) Then, child concatenate the results of the new field. 0 Please sign in to leave a comment.