WillCC
Scholar

Cascade drop down with multiple filtering

I have master data list with all the data. I would like to do a cascade dropdown for my form list

 

It is a 5 tiers dropdown.

  • Platform
  • Vendor -   filter by platform chosen
  • Product - filter by Vendor, Platform chosen
  • code - filter by Product, Vendor, Platform chosen
  • Model  -  filter by Code, Product, Vendor, Platform chosen

(all above are many  to many relationships)

 

Current Nintex o365 only allow me to filter one condition only. the water fall cascade method seems like not able to settle my problem. anyone can help?

0 Kudos
Reply
3 Replies
leighburke
Nintex Employee
Nintex Employee

Re: Cascade drop down with multiple filtering

@WillCC Try using a calculated value field which is a combination of the filter fields and filter by that.

0 Kudos
Reply
WillCC
Scholar

Re: Cascade drop down with multiple filtering

@leighburke Do u mean that I create a calculated field to store the platform and vendor? Then using parse lookup to filter?

 

i used this method before, but my drop down all are many to many relationships. When I choose more the one platform in the drop down. It won’t work .

 

can u provide more details on how the calculated value combinations works?

 

million thanks

0 Kudos
Reply
leighburke
Nintex Employee
Nintex Employee

Re: Cascade drop down with multiple filtering

@WillCC Sorry I missed the many to many part, I was thinking of a similar solution to the parse lookup you mentioned. I'm not sure how you get a filter to work for this OOTB. It might be worth suggesting multiple filters over on our uservoice(https://nintex.uservoice.com/). I will let you know if I think of any other options.

0 Kudos
Reply