How do I...?

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 vote
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Wei Jia shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • John McGarvey commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base