Conditional Enum List Options Based on Another Enum List Column

AppSheet AppSheet Q&A
1

I have two enum list columns: ‘sample category’ and ‘test type.’ Currently, I’m using a formula in the ‘valid if’ field for ‘sample category,’ like this: LIST(“DGA”, “Oil Analysis”). What I’m trying to achieve is that when the user selects ‘DGA’ in the ‘sample category’ column, ‘DGA test’ (related to DGA) should appear in the ‘test type’ column.

Suppose both DGA and Oil Analysis are selected, the ‘test type’ column should display the following options: ‘DGA test’ (related to DGA), ‘BDV,’ ‘Water Content,’ ‘Acidity,’ ‘Colour,’ and ‘Corrosive Sulphur’ (all related to Oil Analysis). In this case, the user must choose ‘DGA test,’ but they can optionally select tests related to Oil Analysis or select all of them

Does this make sense to you?

2

Hey @Steve @AleksiAlkio do you have any idea? Thank you

3

Do you mean?
#1 - If DGA is selected, it should show just “DGA test”
#2 - If Oil Analyses is selected, it shows BDV, Water Content, Acidity, Colour and Corrosive Sulphur
#3 - If both are selected, it should show all of them

4

Yes, correct. Furthermore, I want to set a condition where, if the user selects both DGA and Oil Analysis, the test type column must require them to choose the DGA test. They should also be able to select either all or any one of these values: BDV, Water Content, Acidity, Colour, and Corrosive Sulphur. Does this make sense? @AleksiAlkio