Skip to main content
Nintex Community Menu Bar

We have a UI only model lookup to an aggregate model of quote line items to return the value of a specific product to the Quote model. However when there’s no product in the quote line items the formula returns a -1 value. The model lookup formula we’re using is: MODEL_LOOKUP(QuoteLineSum, sumSubtotal, product2SubFamilyc, “Management Discount”) where subfamily is the specific product we need to pull the value for. We’ve also tried a JS snippet to reevaluate the formula and it still shows -1.


var params = arguments 0],


$ = skuid.$;

alert(‘in js’);


var model = skuid.model.getModel(“Quote”);


model.evaluateFormulaFields();


We’re completely stumped as in the console the QuoteLineSum object has no data rows with a value of -1 but in the Quote object where the UI formula lives, the data rows are showing the -1 value.


Anyone have any insight?

Never mind… We figured out that the model was being queried multiple times and we needed to set a condition to abort instead of deactivate.


The interesting thing though is if you requery the model of a model lookup and the search value is no longer present, it doesn’t clear the formula value (as it should)

You could add an:


IF(IsBlank({{$QuoteLineSum.data.length}}),0,MODEL_LOOKUP(QuoteLineSum, sumSubtotal, product2SubFamilyc, “Management Discount”))

@Skuidward_Tentacles It’s now just showing a value of 0 even with the product added to the quote lines

Try changing the formula to just


{{$QuoteLineSum.data.length}}


to see what the result is. I might have the merge variable format incorrect. It should show the number of rows In the aggregate model.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings