Can a child field be referenced in a formula field on the parent model?

Mark LMark L Member ✭✭
edited June 29 in Questions
I have a model with 2 child relationships on them with LIMIT 1 specified.

I'd like to find the greater value of two fields on these 2 child objects and put them into a formula field on the parent object. Is this possible?

How would I go about referencing the child objects in a formula on the parent object?

Comments

  • Pat VachonPat Vachon Member ✭✭
    edited June 25
    I believe you can use merge syntax in the formula to reference the child record data. Lemeno

    If (
    {{$Model.YourModelName.data.0.ChildRelation01__r.records.0.field}} > {{$Model.YourModelName.data.0.ChildRelation02__r.records.0.field}},
    {{$Model.YourModelName.data.0.ChildRelation01__r.records.0.field}},
    {{$Model.YourModelName.data.0.ChildRelation02__r.records.0.field}}
    )
  • Mark LMark L Member ✭✭
    edited June 29
    Thank you this works!
Sign In or Register to comment.