Hello there!
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?
You need to create a form view for that slice and it will open it correctly.
@Aleksi_Alkio But without making a form view, just using the plus symbol in that slice table view, is it possible?
At this moment unfortunately itโs not possible.
Ok. Thank you!
@Aleksi_Alkio Iโve tried to use this expression on the โTypeโ>โInitial Valueโ:
โIF(#view=get_in,โGet inโ,IF(#view=get_out,โGet Outโ, โDefaultโ))โ
But it was always setting โDefaultโ when I tried to save it. So I realized that when I clicked on the plus symbol, I just change the slice view for a form view unnamed, and because of it the expression didnโt work.
So, is there a expression to catch the last view name?
Perhaps, it would help me end this problem.
We canโt read view names. The reason why your formula always give โDefaultโ as a result is thisโฆ #view=get_in is always FALSE and same with the #view=get_out. Then the only option that you have, is the โDefaultโ.
Ok. Thank you again!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |