Solved

Nintex Forms - lookup with 2 filters

R
Badge +4

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.

icon

Best answer by rauch 7 March 2017, 13:25

View original

27 replies

R
Badge +4

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(/[^a-zs]/gi, '');
        var categoryValue = NWF$("#"+CategoryControl).val().replace(/[^a-zs]/gi, '');
 
        NWF$("#"+HiddenField).val(locationValue+"_"+categoryValue);         
        NWF$("#"+HiddenField).trigger("change"); 
        NWF$("#"+HiddenField).focus();
    } 
}); 

G
Badge +3

LocationControl ? is it the name of your control ?

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings