I need to ask if is there any option or expression that it can detected what slice is selected and set a value in a column.
For exemple, I have a sheet called “Moviment”, and there is a column called “Type” where I can set the value “Get in” or “Get out”. So I made to slices(one for ‘get in’, and another for ‘get out’) and like this I could make two differents table views for each one. But when I select the plus symbol(+) on the bottom rigth conner, the form always open with both options to choose.
What I want is: when the view is a slice of “get out”, the form auto select “Get out” in the “Type” column, and the same for the slice “get in”.
Is there any way?