Change column type in appsheet based on cell value

[gadink_boy]

Is that possible to change column type in appsheet based on cell value?

For example I have 3 different column :

- Division

- Sales Operation

- Customer

If I choose Division = A, and Sales Operation = Sales Visit, then the dropdown Customer will show list of customer in Division A (this is already work).

But if choose Sales Operation = Register New Customer, then the Customer section will change to a blank text box.

Is that possible to do that?

[AleksiAlkio]

Yes you can do that with the Enum column. You need to set the option "Allow other values" as ON. It doesn't change the column type, but you are able to add a new one "outside" of your existing list.