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
Page 1 / 1
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.
Great, thanks!
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}}
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.