How to make specific list options visible depending on the option selected in another list?

Question

Hi everybody,

Is it possible to set specific options visible in a list field depending on the option selected in another list field?

For example, we have list field 1 and list field 2.

List field 1 has the following options. Only one option can be selected.

* A
* B
* C
* D
* E

List field 2 has the following options. Only one option can be selected.

* F
* G
* H
* I
* J
* K
* M

If "B" is selected from list field 1, can we put only  H, I, J, K visible in list field 2?

I'll appreciate if you have any suggestions.

Nic Brough -Adaptavist- · Answer

The cascading select list is by far the best option.  If you're exporting to excel, you can simply split the column later - it's a standard function of spreadsheets (although, as usual, spreadsheets tend to encourage poor data quality - divorcing the two columns makes it easy for a human to destroy the information in there)

Li Huang · Answer

Because we need to export the 2 list fields as 2 separate columns in Excel

Chris Dunne · Answer

Why not use the Cascading Select List custom field type?