Skip to main content
Nintex Community Menu Bar
Question

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

  • July 10, 2024
  • 3 replies
  • 12 views

Forum|alt.badge.img+17

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

3 replies

Forum|alt.badge.img+17
  • Nintex Employee
  • July 10, 2024

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. 


Forum|alt.badge.img+17

Great, thanks!


Forum|alt.badge.img+17

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