Skip to main content
Nintex Community Menu Bar
Question

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

  • Jul 11, 2024 6:10 PM UTC
  • 2 replies
  • 122 views
  • Translate All

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

Translate

Forum|alt.badge.img+10
  • Author
  • Scholar
  • Jul 11, 2024 8:18 PM UTC

Thank you this works!

Translate