elapsing enum data after selected

[Uk]

Hello guys, do you have any ideas with this:

============================================

I have a Table consists of 2 columns

Column 1 = Fruits1  ( data: Apples, Mangoes, Peers)

Column 2 = Fruits2 ( data: Apples, Mangoes, Peers)

Both of them are enum types consist of the same data.

==================================================

Question: 

I just selected APPLES in column fruits1. Is it possible to disappear/hide APPLES from column Fruit2? 

Thanks

[Suvrutt_Gurjar · Accepted solution]

You could use valid_if properties to define the columns' enum options.

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

Column 1  valid_if   

LIST(Apples, Mangoes, Peers)

Column 2  valid_if

LIST(Apples, Mangoes, Peers) - LIST([Column 1])

https://help.appsheet.com/en/articles/4575802-list-subtraction

[Uk]

Thank you @Suvrutt_Gurjar  👍