in my deck view, i dont have a lot of space to put all what i want to see, so im switching to a Card view. but the column that i need to be shown are not available in the dropdown menu.
for example [Timer Left] is shown in deck view but not in card view. this column is type Duration and its also a virtual column.this here is the card view, you can see the [Timer Left] missing
this here is what i currently have, which has [Timer] view
Solved! Go to Solution.
I am replying from mobile, so the following suggestion is not tested and shared scenario not verified.
But you could try type casting the duration column into a text column, something like CONCATENATE([Timer left],"") and display it in the card view.
I am replying from mobile, so the following suggestion is not tested and shared scenario not verified.
But you could try type casting the duration column into a text column, something like CONCATENATE([Timer left],"") and display it in the card view.
Thanks, this Worked!
You are welcome.
I think you could try a few options:
Create a virtual column with one of the following expression options, as it might not be compatible with the view type (but first, check if the view is based on a slice and if that slice contains the [Timer Left] column):
1. TEXT([Timer Left])
2. TOTALMINUTES([Timer Left])
Then, instead of using [Timer Left] directly, use [Timer_Left_VC].
I did not have a slice, when i tried both your option, it kinda worked, but messed up with what i originally had in the [Timer Left] column. but the issue is resolved now, thank you
Please report this to AppSheet support. There should be no reason why you can't display a Duration column in any of these fields.
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |