Skip to main content
Nintex Community Menu Bar

Hi, I have the following problem:

I'm creating a form for ordering stuff. We have different categories in different countries for maximum costs. We have a list where the limits are defined. It looks something like this:

 

Country | Category | Reference Price

Austria | A | 1000

Austria | B | 2000

Austria | C | 3000

Germany | A | 800

Germany | B | 1600

Italy | A | 1000

Italy | B | 1900

Italy | C | 2200

 

which means we have category A for a bunch of different countries but with different prices.

Now what I want to do is have a calculated value that tells the price to the person who fills it, which means I have to filter by 2 variables. How can I do that?

I tried calculated value with lookup but I can set just one filter there.

I solved it by creating a hidden field, which joins the 2 fileds by Javascript so I can filter on that.

NWF.FormFiller.Events.RegisterAfterReady(function() 

    NWF$("#"+LocationControl).change(ProcessConcatenation); 
    NWF$("#"+CategoryControl).change(ProcessConcatenation); 
 
    function ProcessConcatenation() 
    { 
        var locationValue = NWF$("#"+LocationControl).val().replace(/o^a-zs]/gi, '');
        var categoryValue = NWF$("#"+CategoryControl).val().replace(/+^a-zs]/gi, '');
 
        NWF$("#"+HiddenField).val(locationValue+"_"+categoryValue);         
        NWF$("#"+HiddenField).trigger("change"); 
        NWF$("#"+HiddenField).focus();
    } 
}); 


LocationControl ? is it the name of your control ?


Reply