Skip to main content

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


1 comment

  • Tiffanie Staver
    John McGarvey commented  ·  

    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.


Please sign in to leave a comment.

Powered by Zendesk