Skip to main content
Nintex Community Menu Bar
Question

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

  • July 11, 2024
  • 2 replies
  • 98 views

Forum|alt.badge.img+10

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?

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+20

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}}
)


Forum|alt.badge.img+10
  • Author
  • Scholar
  • July 11, 2024

Thank you this works!