Can you use any merge syntax in calculation UI only fields?

I figured I'd ask this question before I spend a ton of time on trial and error. I want to use a UI only field to add the lengths of various models. It seems I would just do something like:
{{$Model.MyModel1.data.length}}+{{$Model.MyModel2.data.length}+{{$Model.MyModel3.data.length}

I remember trying something like this in the past and not having luck. Would this approach work in a UI only calc field or is there another way that I need to pursue this?
Thanks

Skuidward Tentacles (Raymond), Champion

17,866 Points

Posted 3 years ago

3 years ago

Rob Hatch, Official Rep

44,678 Points

You should totally be able to do this. Here are some caveats.

1. Model 1 and Model 2 have to be above the model where your UI only calculation is occuring. Can't calculate what isn't yet known....
2. {{$Model.MyModel1.data.length}} will return a string. You need to wrap it in a "VALUE()" function to translated it into a number that can be calculated.

Start your formula very simply and then build complexity as you are successful with prior stages... It makes debugging much more straightforward.

Comment

3 years ago

Skuidward Tentacles (Raymond), Champion

17,866 Points

Great, thanks!

Comment

3 years ago

Skuidward Tentacles (Raymond), Champion

17,866 Points

Follow up question. How do I reference my newly created UI field in a template. My current attempt is not working:
{{$Model.ServiceRequestDashboard.data.0.ServiceCountAgg}}

Comment