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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Wei Jia shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      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