cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
bejeweledone1
Nintex Newbie

Cascading dropdown filtering with fn-contains

Jump to solution

I am trying to setup a cascading dropdown where the filtering is accomplished using the fn-contains option.

 

The lists involved are Countrys and Holidays.     Countrys is a list of countries, 1 item per country.   Holidays is a list of Holidays.  Each holiday is listed a single time and has an associated column containing the countries it is celebrated in.  This column can contain multiple countries.

 

In the Holiday list are 2 columns containing the country information.   One is a multi-select column and the other is a text column that is populated with the values from the multi-select column via a workflow.

 

What I need to happen:

 

User selects Country from the Country dropdown.   The Holiday dropdown should then only display the Holidays that are celebrated in that country.

 

I was hoping to use the fn-contains formula to do this, but can't seem to make it work.

 

 

 

 

 

Labels: (1)
0 Kudos
Reply
2 Replies
Nintex Employee
Nintex Employee

Re: Cascading dropdown filtering with fn-contains

Jump to solution

Hi,

I was able to acheive this solution without using the contains function.

I created a list named Holidays and listed some events.

Holiday.png

Then created a list named Countries and added some data. It contains the events and which countries celebrate that event.

Countries.png

On a third list I created a form.

The form has a choice control with all the countries listed.

The lookup is then filtered based off of this control.  There was no need to have a contains function as it just worked.

Selecting a country will give you a list of events.

The only issue is that two county lists will need to maintained.  One on the list and one on the Lookup Control

SamForm.png

I have attached my list templates and form in case you need it.

 

View solution in original post

0 Kudos
Reply
bejeweledone1
Nintex Newbie

Re: Cascading dropdown filtering with fn-contains

Jump to solution

Thank you.  I had tried that and it wasn't working.  Turned out that the issue was the name of the column.  In Infopath if the title field in your sharepoint list was renamed to something else, you frequently had to use 'Title' rather than the 'friendly' name you had given it.    I was doing that rather than using the name I gave it.

Once I changed the name, it worked beautifully.

0 Kudos
Reply