Highlighted
Contributor

Setting up dynamic list of values

Hi

We have a requirment as below. 

We are setting up a General List to track the consumption of hardwares at different sites in the world.

There are two columns in this general list. One is Combination which can have  three values (Region/Country/Site).

The next column is Combination_Name. 

The idea is based on the value entered in the Combination column, the Combination_Name should show a relevant list of values. ex. If the users enter Region in the Combination column,then they can select either EMEA or APAC or AMERICAS in the Combination_Name. Same way, if they select Country in the Combination column, thenCombination_Name will have the list of countries from which users will select one.

 

Much appreciate if anybody provides some pointers on how this can be acheived.

Thanks

Prabakaran

 

2 REPLIES 2
Community Boss

Re: Setting up dynamic list of values

Hi,

 

To achieve this, we need a Dynamic list.

 

1. Create a list called Combo Parent, in this list add your Top Level item(i.e, Region, country, siite...)Photo1.png

2. Create a another List called Combination List/Dynamic List, make parent of this list as combo parent list.

Add Respective data under each parent items

Photo1.png

 

3. After this Create a module , as shown below.Photo1.png

1st(Combination) Line item format is Combination Parent, 

2nd(Combination Name) line item format is Combination list, it's a dependent list based on CombiationPhoto1.png

 

Now based on selection in 1st line item, your 2nd line item will show valid values only.

 

Photo1.png

 

Regards,

~Vignesh

Contributor

Re: Setting up dynamic list of values

Thank you very much Vignesh.. It worked..

 

Regards

Prabakaran