clear column based on enum type selection

Hello there, I have a column ref type that should reset if anything else is selected in another column that is enum type:

When "Personal" is selected, the client ref type column shows up and you can select the client. However, if you select "Dealer", the Dealer ref column shows up and if you go back to "Personal", the client ref column should be clear. 

Screen Shot 2022-12-20 at 11.51.37 AM.png

Screen Shot 2022-12-20 at 11.51.46 AM.png

I tried using in the valid if section something like:

If([operacion]<> "personal", "", true)

or

If([operacion]<> "personal", "", [client])

 However, I get and invalid error:

Screen Shot 2022-12-20 at 12.04.31 PM.png

Solved Solved
0 2 109
1 ACCEPTED SOLUTION

 

in the valid if section: 

If ("personal" <> [type], list(), select(client[id], true, false))

 

View solution in original post

2 REPLIES 2

 

in the valid if section: 

If ("personal" <> [type], list(), select(client[id], true, false))

 

Top Labels in this Space