How to show and hide columns from a straight table with a button press?

[Cobran53]

I have a straight table, with columns and hidden columns. I'd like to show one of the hidden columns when the button is pressed. I tried the "Show column if" input, but it's only to allow the user to add a column on the right side or not. Any way that's possible? I'd rather not switch to just a table, even if i know that's possible there.

[DGO · Accepted solution]

Have you tried using a variable?

1. Create a variable - vShowColumn, Value: 0

2. Add a button - Action: set variable value, Variable: vShowColumn, Value: =if(vShowColumn= 0,1,0)

3. In the straight table column 'Show column if': vShowColumn = 1

Clicking the button will toggle the field to show/hide.