In this post we will discuss how we can show cascading drop down in Nintex forms for Office 365 and SharePoint Online. This will be a very basic demo where a country list will be there and a state list will be there. Once user select the country, corresponding states will appear. If you are new to Nintex forms for Office 365, then you can read how to work with Nintex forms for Office 365. To try by your own, you can add Nintex forms for Office 365 app from app store to Office 365 SharePoint Online site. They provide a free 30-days trial, where you can be able to use all the features and test it out.
I have created a Country list which has only one column name as Country, Here i have renamed the Title column to Country. And I have added few items to the Country list and the list looks like below:
You may also read:
– Deploy Administation approved InfoPath forms in SharePoint 2013
– Print issue with SharePoint 2013 InfoPath form
– Draft items not appearing in search results in SharePoint 2013
I have created another list name as “State” which has two columns, One is the State column (I have renamed the default Title column) and other one is lookup column name as “CountryName”. This column is populating from the Country list which we have created above. And I have added few items to the State list also. It appears like below:
Now open the list where you want to add the cascading dropdown. From the Ribbon of the list, click on Nintex forms to customize the list form. This will open the Nintex forms designer. There first we need to add two lookup fields. So expand SharePoint section and then drag and drop List Lookup to the form.
You can also add two labels for the corresponding dropdowns. Here one dropdown for Country and another dropdown for State as shown in the fig below:
Now to let it work as per the requirement we need to do some configuration settings for both the controls. First Double click on Country dropdown, which will open the Control Settings dialog box.
Give a name for the control, the from the Source List, select the Country list. Becuase the data sould come from here. List Coumn name as Title. Here I have put a validation so that user will be bound to select one country. Make Required property as Yes to make it mandatory. The you can also set the error message which you want to display if validation fails. Click OK to Save and the properties should look like below:
Then double click on the State dropdown to open the Control settings window. The same way we have to give a name, then the Souce list as State and column name in the List is Title.
Here we need to do the filtering settings. First choose:
Filter available selections as By a control’s value.
In the where field choose the Column name from the State list. Here the column name is CountryName. This is our lookup column name.
Then Filtered by control choose the Country form field name. Here we have given the name as “frmCountry”. For the State field also we have choosen the Required field as Yes, so that user will bound to choose a state.
Now Publish the form and then Open new form by adding an item to the list. In the form if you will choose a country, corresponding states will appear as shown in the fig below:
Hope this will be helpful.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.