why are some of my columns cant be shown in a card view type?

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] missingthis here is the card view, you can see the [Timer Left] missingthis here is what i currently have, which has [Timer] viewthis here is what i currently have, which has [Timer] view

Solved Solved
0 6 136
1 ACCEPTED 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.

 

View solution in original post

6 REPLIES 6

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.