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?
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}}
)
Thank you this works!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.