Why Text Column change to a button when using valid if List[column name]?

[BInowo]

I used "valid if List[ID] to connect suggestion values based on the previous column selection, but my text column which should have been typed manually instead turned into a button

[Marc_Dillon]

Because that's what valid_if does when you give it a List value. Or when you use a simple IN(). Suppress that behavior by using the following:

AND( TRUE , IN( [_THIS] , List[id] ) )

[BInowo]

I've done it, but unfortunately it makes the suggested value in the next column disconnected. i mean if i change JKO to BYU, suggestion values in column hari kunjungan and/ toko is not change

This might give you more insight into what I'm working on:

[Marc_Dillon]

What suggested values are you using in the next column? How do you mean it is "disconnected"?

[BInowo]

nothing. and for "disconnected", it means not match with selected value in previous drop down

[Marc_Dillon]

Why did you mention suggested values if you're not using it? How would the value in one column match the value in another column? You need to be more clear here.

[SkrOYC]

Dependent drop-downs - AppSheet Help